The following collations are supplied with Sybase IQ. You can obtain the list of all available collations by typing the following command at the command prompt:
SELECT * FROM SYS.SYSCOLLATION
Collation label |
Description |
|---|---|
ISO_BINENG |
Binary ordering, English ISO/ASCII 7-bit letter case mappings |
874THAIBIN |
Code Page 874, Windows Thai |
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 |
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 |
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_JAPAN |
Japanese EUC JIS X 0208-1990 and JIS X 0212-1990 Encoding |
EUC_CHINA |
Simplified Chinese GB 2312-80 Encoding |
EUC_TAIWAN |
Taiwanese Big 5 Encoding |
EUC_KOREA |
Korean KS C 5601-1992 Encoding, Johab |
ISO_1 |
ISO8859-1, Latin 1, Western |
ISO1LATIN1 |
ISO8859-1, ISO Latin 1, Western, Latin 1 Ordering |
ISO9LATIN1 |
ISO8859-15, ISO Latin 9, Western, Latin 1 Ordering |
UTF8 |
Unicode Transformation Format-8, 8-bit multibyte encoding for Unicode |
The following collations are recommended because they provide the most likely match to the character set being used by the application: they have an appropriate sort order and support for the symbols and accented characters required for each specific language. Some languages do not have a recommended UNIX collation.
Language |
Windows collations |
UNIX collations |
|---|---|---|
Western European (including English, French, German, Italian, Portuguese, and Spanish) |
1252LATIN1 |
ISO9LATIN1, ISO1LATIN1 |
Eastern European (including Croatian, Czech, Hungarian, Romanian, Serbian, Slovakian, and Slovenian) |
1250LATIN2 |
|
Arabic |
1256ARA |
|
Greek |
1253ELL |
|
Hebrew |
1255HEB |
|
Japanese |
932JPN |
EUC_JAPAN |
Korean |
949KOR |
EUC_KOREA |
Lithuanian |
1257LIT |
|
Polish |
1250POL |
|
Russian and Ukrainian |
1251CYR |
|
Simplified Chinese |
936ZHO |
EUC_CHINA |
Spanish |
1252SPA |
ISOLATIN1, ISO9LATIN1 |
Thai |
874THAIBIN |
874THAIBIN |
Traditional Chinese |
950ZHO_TW |
|
Traditional Chinese + HKSCS |
950ZHO_HK |
|
Turkish |
1254TRK |
