Changing the default character set and sort order

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.

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