Understanding Character Set Translation

SAP Sybase IQ can perform character set translation among character sets that represent the same characters, but are located at different positions in the character set or code page.

A degree of compatibility between the character sets is required for this translation. For example, character set translation is possible between EUC-JIS and cp932 character sets, but not between EUC-JIS and cp1252.

These topics describe how SAP Sybase IQ carries out character set translation. This information is for users who may be deploying applications or databases in a multicharacter set environment.

• Character Translation for Database Messages
  Error and other messages from the database software are held in a language resource library. Localized versions of this library are provided with localized versions of SAP Sybase IQ.
• Connection Strings and Character Sets
  Connection strings present a special case for character set translation.
• Avoiding Character Set Translation
  There is a performance cost associated with character set translation. If you can set up an environment for which no character set translation is required, you need not consider this cost, and your setup is simpler to maintain.