Following is the list of supported CHAR collations in SQL Anywhere. This list can also be obtained by executing the following command at a command prompt:
dbinit -l
| 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 are available for compatibility with older versions of SQL Anywhere, or for special purposes. To see the full list of supported alternate collations, execute the following command at a command prompt:
dbinit -l+