Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » International languages and character sets » Character set and collation reference information


Supported and alternate collations

The following table lists compatibility collations introduced in SQL Anywhere version 8 that can be used with the SORTKEY and COMPARE functions.

In SQL Anywhere version 10, implementation of the SORTKEY and COMPARE functions changed to ICU (International Components for Unicode) and UCA (Unicode Collation Algorithm) and collation names now map to the UCA collation. Sorting and comparison in SQL Anywhere version 10 and later may not be identical to earlier versions of SQL Anywhere.

See also
Collation label Description
874THAIBIN Code Page 874, Windows Thai, ISO8859-11, binary ordering
932JPN Code Page 932, Japanese Shift-JIS with Microsoft extensions
936ZHO Code Page 936, Simplified Chinese, PRC GBK 2312-80 8-bit encoding
949KOR Code Page 949, Korean KS C 5601-1987 encoding, Wansung
950ZHO_HK Code Page 950, Traditional Chinese, Big 5 encoding with HKSCS
950ZHO_TW Code Page 950, Traditional Chinese, Big 5 encoding
1250LATIN2 Code Page 1250, Windows Latin 2, Central/Eastern European
1250POL Code Page 1250, Windows Latin 2, Polish
1251CYR Code Page 1251, Cyrillic
1252LATIN1 Code Page 1252, Windows Latin 1, Western
1252NOR Code Page 1252, Windows Latin 1, Norwegian
1252SPA Code Page 1252, Windows Latin 1, Spanish
1252SWEFIN Code Page 1252, Windows Latin 1, Swedish/Finnish
1253ELL Code Page 1253, Windows Greek, ISO8859-7 with extensions
1254TRK Code Page 1254, Windows Latin 5, Turkish, ISO 8859-9 with extensions
1254TRKALT Code Page 1254, Windows Turkish, ISO8859-9 with extensions, I-dot equals I-no-dot
1255HEB Code Page 1255, Windows Hebrew, ISO8859-8 with extensions
1256ARA Code Page 1256, Windows Arabic, ISO8859-6 with extensions
1257LIT Code Page 1257, Lithuanian
EUC_CHINA Simplified Chinese GB 2312-80 Encoding
EUC_JAPAN Japanese EUC JIS X 0208-1990 and JIS X 0212-1990 Encoding
EUC_KOREA Korean KS C 5601-1992 Encoding, Johab
EUC_TAIWAN Taiwanese Big 5 Encoding
ISO1LATIN1 ISO8859-1, ISO Latin 1, Western, Latin 1 Ordering
ISO9LATIN1 ISO8859-15, ISO Latin 9, Western, Latin 1 Ordering
ISO_1 ISO8859-1, Latin 1, Western
ISO_BINENG Binary ordering, English ISO/ASCII 7-bit letter case mappings
UCA Standard default UCA collation
UTF8BIN UTF-8, 8-bit multibyte encoding for Unicode, binary ordering
Alternate collations

Alternate collations are available for compatibility with older versions of SQL Anywhere, or for special purposes. To see the full list of supported alternate collations, run the following command:

dbinit -l+
Adaptive Server Enterprise collations

The following table lists the supported Adaptive Server Enterprise collations for use with features such as the SORTKEY function.

Description Collation name Collation ID
Default Unicode multilingual default 0
CP 850 Alternative: no accent altnoacc 39
CP 850 Alternative: lowercase first altdict 45
CP 850 Western European: no case, preference altnocsp 46
CP 850 Scandinavian dictionary scandict 47
CP 850 Scandinavian: no case, preference scannocp 48
GB Pinyin gbpinyin n/a
Binary sort binary 50
Latin-1 English, French, German dictionary dict 51
Latin-1 English, French, German no case nocase 52
Latin-1 English, French, German no case, preference nocasep 53
Latin-1 English, French, German no accent noaccent 54
Latin-1 Spanish dictionary espdict 55
Latin-1 Spanish no case espnocs 56
Latin-1 Spanish no accent espnoac 57
ISO 8859-5 Russian dictionary rusdict 58
ISO 8859-5 Russian no case rusnocs 59
ISO 8859-5 Cyrillic dictionary cyrdict 63
ISO 8859-5 Cyrillic no case cyrnocs 64
ISO 8859-7 Greek dictionary elldict 65
ISO 8859-2 Hungarian dictionary hundict 69
ISO 8859-2 Hungarian no accents hunnoac 70
ISO 8859-2 Hungarian no case hunnocs 71
ISO 8859-5 Turkish dictionary turdict 72
ISO 8859-5 Turkish no accents turnoac 73
ISO 8859-5 Turkish no case turnocs 74
CP 874 (TIS 620) Royal Thai dictionary thaidict 1
ISO 14651 ordering standard 14651 22
Shift-JIS binary order sjisbin 179
Unicode UTF-8 binary sort utf8bin 24
EUC JIS binary order eucjisbn 192
GB2312 binary order gb2312bn 137
CP932 MS binary order cp932bin 129
Big5 binary order big5bin 194
EUC KSC binary order euckscbn 161