Configuring SAP ASE for Other Character Sets

Configure SAP ASE with the character set and sort order for your language. Your system messages appear in the default language, English.


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. Replace character_set with the SAP name for your character set.

  1. Use the charset utility to load the default character set and sort order.
  2. Use charset to load any additional character sets.

    If you plan to use the SAP ASE 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. Use isql to 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.

    Replace character_set with the SAP name for your character set.

  5. Shut down the server to start the reconfiguration process.
  6. Restart the server. Use Windows Service Manager from your SAP Program Group or from a command prompt, invoke RUN_server_name.bat from %SYBASE%\%SYBASE_ASE%\install.
  7. Restart a second time to bring the server up in a stable state.
Related reference
charset Utility
Available Sort Orders
SAP ASE Character Set Names