Sybase DC35823-01-1500-04 Server User Manual


 
CHAPTER 7 Customizing Localization for Adaptive Server
Configuration Guide 89
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.