Sybase DC35823-01-1500-04 manual Character set conversion, Conversions between server and client

CHAPTER 7 Customizing Localization for Adaptive Server

Character set conversion

Backup Server passes messages to Adaptive Server in the client’s language and in the Adaptive Server character set. Adaptive Server then converts the messages and issues them in the client’s language and character set. Keep the following requirements in mind when selecting a character set:

•In a heterogeneous environment, Adaptive Server and Backup Server may need to communicate with clients running on different platforms and using different character sets. To maintain data integrity, the server converts the code between the character sets.

•To use the built-in conversion, you must install the character set definition files on the server for all the character sets being used by your clients. Built-in conversion support is available for many character sets.

•Unilib conversion support is available for all character sets supported by Sybase. To enable Unilib conversion, you must use sp_configure and turn enable unicode conversions on. For more information, see the System Administration Guide.

If either Adaptive Server or Backup Server does not support a client’s language or character set, that server issues a warning message. Errors also occur when the Backup Server character set is not compatible with the Adaptive Server character set.

Character set conversion is supported only between character sets for the same language or between character sets in the same language group.

For example, automatic character set conversion is supported between the character sets for the Western European languages: ASCII 8, CP 437, CP 850, CP 860, CP 863, CP 1252, ISO 8859-1, ISO 8859-15, and ROMAN8. Similarly, conversion is supported between the character sets for Japanese: CP 932, EUC-JIS, Shift-JIS, and DEC-Kanji.

However, code conversion is not supported between any of the Western European language character sets and the Japanese character sets. For more information about supported conversions, see the System Administration Guide.

Conversions between server and client

If Adaptive Server does not support the client’s language or character set, the client can connect with the server, but no character conversions occur.

Configuration Guide 89