Sybase DC35823-01-1500-04 manual Default character sets for servers

CHAPTER 7 Customizing Localization for Adaptive Server

Default character sets for servers

The default character set is the character set in which data is encoded and stored on the Adaptive Server databases.

Changing the default language and character set

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.

After srvbuild configures a new Adaptive Server, it 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:

•us_english language

•iso_1 character set (on HP-UX platforms, use Roman8)

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

You can:

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

By default, when Adaptive Server and Backup Server are installed on IBM, and SUN Solaris systems, the installation installs the character set files for ISO 8859-1, which supports the Western European languages.

Configuration Guide 83