Sybase DC35823-01-1500-04 manual Supported character sets

Overview of localization support

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.

84 Adaptive Server Enterprise