Sybase 12.4.2 manual 332

Understanding collations

•When setting up data sources for Windows-based ODBC applications, do choose the Adaptive Server Anywhere or Adaptive Server IQ translation driver in the ODBC data source configuration.

The translation driver converts between the OEM code page on your machine and the ANSI code page used by Windows. If the database collation is a different OEM code page than the one on your machine, an incorrect translation will be applied.

Both DBISQL and Sybase Central detect whether the database collation is ANSI or OEM by checking the first few characters, and either enable or disable translation as needed.

For more information about code page translation in DBISQL, see the

CHAR_OEM_TRANSLATION option in the Adaptive Server IQ Reference

Manual.

Notes on ANSI collations

The ISO_1 collation ISO_1 is provided for compatibility with the Adaptive Server Enterprise default ISO_1 collation. The differences are as follows:

•The lower case letter sharp s (\xDF) sorts with the lower case s in Adaptive Server IQ and Adaptive Server Anywhere, but after ss in Adaptive Server Enterprise.

The 1252LATIN1 collation

The WIN_LATIN1 collation

•The ligatures corresponding to AE and ae (\xC6 and \xE6) sort after A and a respectively in Adaptive Server IQ and Adaptive Server Anywhere, but after AE and ae in Adaptive Server Enterprise.

This collation is the same as WIN_LATIN1 (see below), but includes the euro currency symbol and several other characters (Z-with-caron and z-with-caron). If you do not wish to use the default collation ISO_BINENG, the recommended collation in most cases is 1252LATIN1 on Windows NT, and ISO1LATIN1 on UNIX.

Windows NT service patch 4 changes the default character set in many locales to a new 1252 character set on which 1252 LATIN1 is based. If you have this service patch, you should use this collation instead of WIN_LATIN1.

The euro symbol sorts with the other currency symbols.

WIN_LATIN1 is similar to ISO_1, except that Windows has defined characters in places where ISO_1 says "undefined", specifically the range \x80-\xBF. The differences from Adaptive Server Enterprise's ISO_1 are as follows:

332