Filter
Top Products
CHAPTER 9 International Languages and Character Sets
333
• The upper case and lower case Icelandic Eth (\xD0 and \xF0) is sorted with
D in Adaptive Server IQ and Adaptive Server Anywhere, but after all
other letters in Adaptive Server Enterprise.
• The upper case and lower case Icelandic Thorn (\xD0 and \xF0) is sorted
with T in Adaptive Server IQ and Adaptive Server Anywhere, but after all
other letters in Adaptive Server Enterprise.
• The upper-case Y-diaresis (\x9F) is sorted with Y in Adaptive Server IQ
and Adaptive Server Anywhere, and case converts with lower-case Y-
diaresis (\xFF). In Adaptive Server Enterprise it is undefined and sorts
after \x9E.
• 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.
• Ligatures are two characters combined into a single character. 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 ligatures corresponding to OE and oe (\x8C and \x9C) sort with O in
Adaptive Server IQ and Adaptive Server Anywhere, but after OE and oe
in Adaptive Server Enterprise.
• The upper case and lower case letter S with caron (\x8A and \x9A) sorts
with S in Adaptive Server IQ and Adaptive Server Anywhere, but is
undefined in Adaptive Server Enterprise, sorting after \x89 and \x99.
The ISO1LATIN1
collation
This collation is the same as ISO_1, but with sorting for values in the range A0-
BF. For compatibility with Adaptive Server Enterprise, the ISO_1 collation has
no characters for 0xA0-0xBF. However the ISO Latin 1 character set on which
it is based does have characters in these positions. The ISO1LATIN1 collation
reflects the characters in these positions.
If you are not concerned with Adaptive Server Enterprise compatibility,
ISO1LATIN1 is generally recommended instead of ISO_1.
The ISO9LATIN1
collation
This collation is the same as ISO1LATIN1, but includes the euro currency
symbol and the other new characters included in the 1252 LATIN1 collation.
If your machine uses the ISO Latin 9 character set, and you are willing to
sacrifice some of the optimal performance of ISO_BINENG, then you should
use this collation.