Configuring Adaptive Server for Other Character Sets

Configure Adaptive Server with the character set and sort order for your language.

Prerequisites

The server must be running and you must have system administrator privileges.

Task

Use the charset utility to load the default character set and 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. Replace character_set with the Sybase name for your character set.
Use charset utility to load any additional character sets.

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
```
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. Replace character_set with the Sybase name for your character set.
Shut down the server to start the reconfiguration process.
Use your normal process on your UNIX system to restarts the server, usually by invoking one of the RUN_xxx scripts from $SYBASE/$SYBASE_ASE/install.
The server starts, rebuilds all the system indexes, then shuts down. Restart a second time to bring the server up in a stable state. Your system messages appear in the default language, English.