Configuring Adaptive Server for other character sets

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.

  1. 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 6-17. Replace character_set with the Sybase name for your character set. See Table 6-18.

  2. 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.

  3. Using isql, log in to your server as “sa” and select the master database.

    1> use master 2> go

  4. 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 6-17. Replace character_set with the Sybase name for your character set. See Table 6-18.

  5. Shut down the server to start the reconfiguration process.

  6. Restart the server. Use Windows NT Service Manager from your Sybase Program Group or from a command prompt, invoke RUN_server_name.bat from %SYBASE%\%SYBASE_ASE%\install.

  7. The server starts, rebuilds all the system indexes, then shuts down. Restart a second time to bring the server up in a stable state.