ANSI or OEM?

Sybase IQ collations are based on code pages that are designated as either ANSI or OEM. In most cases, use of 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 iAnywhere JDBC driver handles character set translation.