ANSI and OEM Code Pages

SAP Sybase IQ collations are based on code pages that are designated as either ANSI or OEM.

Use an ANSI code page in most cases. If you use OEM, choose a code page that matches the OEM code pages on your users' client machines.

Note: Do not use a separate translation driver. Translation drivers interfere with the server's character set translation, and are likely to result in data corruption.

For Interactive SQL, the iAnywhere JDBC driver handles character set translation.

ANSI ISO_1 Collation
ISO_1 is provided for compatibility with the Adaptive Server Enterprise default ISO_1 collation.
ANSI 1252LATIN1 Collation
This collation includes the Euro currency symbol and several other characters such as Z-with-caron (Ž) and z-with-caron (ž).
ANSI ISO1LATIN1 Collation
This collation is the same as ISO_1, but includes sorting for values in the range A0 - BF.
ANSI ISO9LATIN1 Collation
This collation is the same as ISO1LATIN1, but includes the Euro currency symbol and the other new characters included in the 1252LATIN1 collation.

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com