Default character sets for servers, Changing the default language and character set – Sybase DC35823-01-1500-04 User Manual

Page 99

Advertising
background image

CHAPTER 7 Customizing Localization for Adaptive Server

Configuration Guide

83

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.

Advertising