WARNING! Make all changes to the character set and sort order for a new Adaptive Server before creating any user databases or making any changes to the Sybase-supplied databases. Changing the character set and sort order after data or data structures have been added to Adaptive Server may require additional steps. To change the character set or sort order after you have added data, see the System Administration Guide.
When you installed Adaptive Server, srvbuild displays a message box asking if you want to localize your Adaptive Server to a language other than us_english and if you want to use a character set or sort order other than the default.
srvbuild creates an Adaptive Server with the following defaults:
iso_1 character set
roman8 character set
Binary sort order
Valid language options depend on what language modules were unloaded from the distribution media onto your system.
All character sets are copied from the distribution media by default.
Click No to accept the defaults.
Click Yes to change the defaults.
The sqlloc menu is displayed. sqlloc is the GUI utility used to change default languages, character sets, and sort orders.
For information on using sqlloc, see Chapter 7, “Customizing Localization for Adaptive Server.”
By default, when Adaptive Server and Backup Server are installed on Compaq Tru64, IBM, SUN Solaris systems, the installation installs the character set files for ISO 8859-1 which supports the Western European languages.
By default, when Adaptive Server and Backup Server are installed on HP systems, the installation installs the character set files for ROMAN8 which supports the Western European languages.
sqlloc is not available on Mac OS X.
Use the charset script to change the character set and sort order. Use the langinstall utility to install languages, and sp_modifylogin to specify language preferences.