Displaying difference between revision 6 and 5 of Wiki page:Add Unicode Character Set to Sybase ASE
Please wait, loading revisions...
display as  
!!!Add Unicode Character Set to Sybase ASE In order to store Unicode characters in a Sybase database, an additional character set needs to be added to the server for Sybase ASE 12.5 and 15. This page describes how to use syconfig on Windows and sqlloc on Linux to configure ASE. !!Configure ASE with syconfig on Windows Start syconfig.exe in directory $SYBASE\ASE-12_5\bin. In the window that comes up, click on 'Configure Adaptive Server', pick your server from the list and login to the server as the sa user. You will see the following __Configure Adaptive Server__ window then. [CB:/displayDocument/ConfigureAdaptiveServer.png?object_comment_id=42] Click on Language to get to the __Language Options__ window. [CB:/displayDocument/LanguageOptions.png?object_comment_id=40] Press Add/Remove below Character to open the __Install Character Sets__ window. [CB:/displayDocument/InstallCharacterSets.png?object_comment_id=41] Select Unicode in the list of available character sets, add it as an additional character set for the server and press OK. Click on Set Default below Character Set in the __Language Options__ window. [CB:/displayDocument/ChangeDefaultCharaceterSet.png?object_comment_id=43] In the __Change Default Characeter Set__ window select Unicode and press OK. Leave the __Configure Adaptive Server__ window by pressing OK and the press Save to update the server. This may take a while. !!Configure ASE with sqlloc on LinuxINUX Use the sqlloc utility to change the default character set, language, and sort order. 1. Source environment variables file. (SYBASE.csh or SYBASE.sh]) 2. Execute $SYBASE/ASE-15_0/bin/sqlloc. 3. Select Configure Adaptive Server. 4. Select the Adaptive Server you want to configure. 5. Enter your login and password 6. Click Language to set the defaults for character sets, language, and sort orders Pick UTF-8 from the list and press OK. The new character set will now be installed to the server and becomes the default character set. This takes a while.