To configure Adaptive Server with the character set and sort order for your language, complete the following steps. Your system messages appear in the default language, English.
Use the charset utility to load the default character set and sort order.
To use the charset the server must be running and you must have System Administrator privileges. Use the file name of the sort order:
$SYBASE/SYBASE_ASE/bin/charset -Usa -Ppassword -Sserver_name sort_order_file character_set
Replace sort_order_file with the name of the sort order file. See Table 7-17. Replace character_set with the Sybase name for your character set. See Table 7-18.
Use the charset utility to load any additional character sets. See “charset utility” for more about this utility.
If you plan to use the Adaptive Server built-in character-set conversions, you must load the character-set definition files for all the characters set on your client platforms. If you are using the Unilib character-set conversions, you do not need to do this.
Using isql, log in to your server as “sa” and select the master database.
1> use master 2> go
Use the ID of the sort order to configure your server for the new character set and sort order.
1> sp_configure "default sort_order_id", 2> sort_order_id, "character_set" 3> go
Replace sort_order_id with the ID for your sort order. See Table 7-17. Replace character_set with the Sybase name for your character set. See Table 7-18.
Shut down the server to start the reconfiguration process.
Use your normal process on your UNIX system to reboot the server, usually by invoking one of the RUN_xxx scripts from $SYBASE/$SYBASE_ASE/install.
The server boots, rebuilds all the system indexes, then shuts down. Reboot a second time to bring the server up in a stable state.