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

Page 100

Advertising
background image

Overview of localization support

84

Adaptive Server Enterprise

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.

Changing the default character set for servers

You can select any character set as the default on Adaptive Server, including
character sets that are not the platform default character sets. Keep the
following guidelines in mind when selecting a new default character set:

To avoid conversion errors or overhead, determine the default character
set based on the character set used by your clients.

For example, if most of your clients use ISO 8859-1, you can minimize the
amount of data conversion that has to occur by specifying ISO 8859-1.

If your server is operating in a heterogeneous language environment,
choose a character set that works with all the character sets needed. Often,
this is Unicode (UTF-8).

Warning!

Make all changes to the default 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 can cause incorrect
behavior. To change the character set or sort order after you have added data,
see the System Administration Guide.

Supported character sets

The following language, scripts and character sets are supported by Adaptive
Server:

Arabic – see Table 7-1 on page 85.

Baltic – see Table 7-2 on page 85.

Chinese, Simplified – see Table 7-3 on page 86.

Chinese, Traditional – see Table 7-4 on page 86

Cyrillic – see Table 7-5 on page 86.

Eastern European – see Table 7-6 on page 86.

Greek – see Table 7-7 on page 87.

Advertising