Sybase 12.4.2 User Manual
Understanding collations
332
•
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.
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.
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.
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.
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:
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 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.
The 1252LATIN1
collation
collation
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.
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.
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.
The WIN_LATIN1
collation
collation
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:
in places where ISO_1 says "undefined", specifically the range \x80-\xBF. The
differences from Adaptive Server Enterprise's ISO_1 are as follows: