While SAP Sybase IQ recognizes the names of hundreds of character sets, code pages, encodings, and collations, this topic lists those that are recommended for use with Windows and Unix platforms, depending on the language in use.
Use the iqinit -le option to obtain a list of all the available character set labels for an SAP Sybase IQ database. Use the iqinit -l option to obtain a list of available collations for an SAP Sybase IQ database.
Where a character set encoding or label must be specified, use the value from the Character set label column or one of the labels listed by iqinit -le. Where a collation must be specified, use the value from the Collation or Alternate collation column or one of the labels listed by iqinit -l.
| Language | Windows Code Page | Character set label | Collation | Alternate collation |
|---|---|---|---|---|
| Arabic | 1256 | Windows-1256 | 1256ARA | |
| Central and Eastern European | 1250 | Windows-1250 | 1250LATIN2 | |
| Danish | 1252 | Windows-1252 | 1252LATIN1 | |
| Dutch | 1252 | Windows-1252 | 1252LATIN1 | |
| English | 1252 | Windows-1252 | 1252LATIN1 | |
| Finnish | 1252 | Windows-1252 | 1252SWEFIN | |
| French | 1252 | Windows-1252 | 1252LATIN1 | |
| German | 1252 | Windows-1252 | 1252LATIN1 | |
| Greek | 1253 | Windows-1253 | 1253ELL | |
| Hebrew | 1253 | Windows-1253 | 1255HEB | |
| Italian | 1252 | Windows-1252 | 1252LATIN1 | |
| Japanese | 932 | Windows-31J | 932JPN | |
| Korean | 949 | IBM949 | 949KOR | |
| Lithuanian | 1257 | Windows-1257 | 1257LIT | |
| Norwegian | 1252 | Windows-1252 | 1252NOR | |
| Polish | 1250 | Windows-1250 | 1250POL | |
| Portuguese | 1252 | Windows-1252 | 1252LATIN1 | |
| Russian | 1251 | Windows-1251 | 1251CYR | |
| Simplified Chinese | 936 | GBK | 936ZHO | |
| Spanish | 1252 | Windows-1252 | 1252SPA | |
| Swedish | 1252 | Windows-1252 | 1252SWEFIN | |
| Thai | 874 | TIS-620 | 874THAIBIN | |
| Traditional Chinese - Hong Kong | 950 | Big5-HKSCS | 950ZHO_HK | |
| Traditional Chinese - Taiwan | 950 | Big5 | 950ZHO_TW | |
| Turkish | 1254 | Windows-1254 | 1254TRK | 1254TRKALT |
| Ukrainian | 1251 | Windows-1251 | 1251CYR | |
| Western European | 1252 | Windows-1252 | 1252LATIN1 |
| Language | Character set label | Collation | Alternate collation |
|---|---|---|---|
| Arabic | ISO_8859-6:1987 | UCA | |
| Central and Eastern European | ISO_8859-2:1987 | UCA | |
| Danish | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Dutch | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| English | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Finnish | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| French | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| German | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Greek | ISO_8859-7:1987 | UCA | |
| Hebrew | ISO_8859-8:1988 | UCA | |
| Italian | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Japanese | EUC-JP1 | EUC_JAPAN | |
| Korean | EUC-KR | EUC_KOREA | |
| Lithuanian | (use UTF-8) | UCA or UTF8BIN | |
| Norwegian | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Polish | ISO_8859-2:1987 | UCA | |
| Portuguese | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Russian | ISO_8859-5:1988 | UCA | |
| Simplified Chinese | GB2312 | EUC_CHINA | |
| Spanish | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Swedish | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
| Thai | (use UTF-8) | UCA or UTF8BIN | |
| Traditional Chinese - Hong Kong | Big5-HKSCS | 950ZHO_HK | 950TWN |
| Traditional Chinese - Taiwan | EUC-TW | EUC_TAIWAN | |
| Traditional Chinese - Taiwan | Big5 | 950ZHO_TW | |
| Turkish | ISO_8859-9:1989 | 920TRK | |
| Ukrainian | ISO_8859-5:1988 | UCA | |
| Western European | ISO-8859-15 | ISO9LATIN1 | ISO1LATIN1 |
1 EUC-JP is an alternate label for the SAP Sybase IQ label Extended_UNIX_Code_Packed_Format_for_Japanese.