To configure the Cluster Edition 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 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 17-18. Replace character_set with the Sybase name for your character set. See Table 17-19.
Use charset utility to load any additional character sets. See “charset utility”.
To use the Cluster Edition built-in character set conversions, 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 sortorder_id", 2> sort_order_id, "character_set" 3> go
Replace sort_order_id with the ID for your sort order. See Table 17-18. Replace character_set with the Sybase name for your character set. See Table 17-19.
Shut down the cluster. You can use sybcluster, the Adaptive Server plug-in, or, if you configured the cluster manually, a command line option.
Restart any instance in the cluster using sybcluster or the Adaptive Server plug-in.
If you configured the cluster manually, use your normal
process on UNIX systems to restart the instance. Typically, this
means invoking the following dataserver command:
$SYBASE/$SYBASE_ASE/BIN/dataserver --quorum_dev=quorum_path --instance=instance_name
The instance starts, rebuilds all the system indexes, then shuts down. Restart a second time to bring the instance up in a stable state.
Check the cluster log file to verify that the charset and sortorder changes have completed successfully.
