The following table lists compatibility collations that can be used with the SORTKEY and COMPARE functions.
| 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 |
| 1252BIN | Code Page 1252, Windows Latin 1, binary ordering |
| 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 |
| CESU8BIN | CESU-8, 8-bit multibyte encoding for Unicode, binary ordering |
| 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 are available for compatibility with older versions of SAP Sybase IQ, or for special purposes. To see the full list of supported alternate collations, run the following command:
iqinit -l+
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 |