Contents Index Creating databases for Windows CE Notes on ANSI collations

ASA Database Administration Guide
  International Languages and Character Sets
    Understanding collations

ANSI or OEM?


Adaptive Server Anywhere collations are based on code pages that are designated as either ANSI or OEM. In most cases, using an ANSI code page is recommended. If you use OEM, choose a code page that matches the OEM code pages on your users' client machines.

You should not use a separate translation driver under any circumstance. Translation drivers interfere with the server's character set translation. Using a separate translation driver will likely result in data corruption.

For Interactive SQL and Sybase Central, the jConnect driver or the iAnywhere JDBC driver (depending on which method you use) handles character set translation.


Contents Index Creating databases for Windows CE Notes on ANSI collations