Changing the character set for Sybase ASE 16

If you need to change char set you can invoke the following commands on your server
1. Set LD_LIBRARY_PATH environment variable. Otherwise you’ll get

ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED

export LD_LIBRARY_PATH=/opt/sybase/OCS-16_0/lib3p64/

2. Invoke charset utility with

/opt/sybase/ASE-16_0/bin//charset -U${ASE_ADMIN} -P${ASE_ADMIN_PWD} -S${ASE_SERVER} binary.srt utf8

3. Invoke isql utility with

/opt/sybase/OCS-16_0/bin/isql -Usa -PmyPassword -SMYSYBASE
>sp_configure 'default sortorder id', 50, 'utf8'
>go

4. Restart Sybase ASE server

Before:

After:

For more details refer to Sybase ASE 16 documentation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s