Sybase 12.4.2 manual 333

CHAPTER 9 International Languages and Character Sets

The ISO1LATIN1 collation

The ISO9LATIN1 collation

•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.

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.

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.

333