Understanding Character Set Translation

Sybase IQ can carry out character set translation among character sets that represent the same characters, but at different positions in the character set or code page.

There needs to be a degree of compatibility between the character sets for this character set translation to be possible. 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 Sybase IQ carries out character set translation. This information is provided for advanced users, such as those 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 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.