Changing default character set, sort order or language

Adaptive Server supports a wide variety of character sets, and you can localize error messages to suit your user community. By default, Adaptive Server is installed with a default character set of iso_1 (ISO 8859-1), a binary sort order, and English as the default language. The changes required are described in this section.

Complete these steps before you add any user data to Adaptive Server. If your server contains data, follow the procedures outlined in the System Administration Guide to save and restore it.

Use the charset utility to change the default character set. At this time, you can only run this utility from the UNIX/Linux shell, so you must open a terminal window to do this. charset is at $SYBASE/ASE-15_0/bin/charset.

StepsChanging Adaptive Server defaults

  1. Run the charset utility to add the character set to Adaptive Server’s system catalogs.

  2. Execute sp_configure to set the default character set.

  3. Restart the server. The server comes up, performs any necessary reconfiguration it needs to do internally, and then shuts itself down. You can then restart it.