ASA Database Administration Guide
International Languages and Character Sets
Understanding character sets in software
The following table lists code pages supported in DBISQL. For more information, see Opening Interactive SQL using the dbisql command-line utilityor Interactive SQL utility options.
Code Page | Description |
---|---|
1252 | Windows Latin-1 |
037 | USA, Canada (Bilingual, French), Netherlands, Portugal, Brazil, Australia |
273 | IBM Austria, Germany |
277 | IBM Denmark, Norway |
278 | IBM Finland, Sweden |
280 | IBM Italy |
284 | IBM Catalan/Spain, Spanish Latin America |
285 | IBM United Kingdom, Ireland |
297 | IBM France |
420 | IBM Arabic |
424 | IBM Hebrew |
437 | MS-DOS United States, Australia, New Zealand, South Africa |
500 | EBCDIC 500V1 |
737 | PC Greek |
775 | PC Baltic |
838 | IBM Thailand extended SBCS |
850 | MS-DOS Latin-1 |
852 | MS-DOS Latin-2 |
855 | IBM Cyrillic |
856 | IBM Hebrew |
857 | IBM Turkish |
858 | Variant of Cp850 with Euro character |
860 | MS-DOS Portuguese |
861 | MS-DOS Icelandic |
862 | PC Hebrew |
863 | MS-DOS Canadian French |
864 | PC Arabic |
865 | MS-DOS Nordic |
866 | MS-DOS Russian |
868 | MS-DOS Pakistan |
869 | IBM Modern Greek |
870 | IBM Multilingual Latin-2 |
871 | IBM Iceland |
874 | IBM Thai |
875 | IBM Greek |
918 | IBM Pakistan (Urdu) |
921 | IBM Latvia, Lithuania (AIX, DOS) |
922 | IBM Estonia (AIX, DOS) |
930 | Japanese Katakana-Kanji mixed with 4370 UDC, superset of 5026 |
933 | Korean Mixed with 1880 UDC, superset of 5029 |
935 | Simplified Chinese Host mixed with 1880 UDC, superset of 5031 |
937 | Traditional Chinese Host mixed with 6204 UDC, superset of 5033 |
939 | Japanese Latin Kanji mixed with 4370 UDC, superset of 5035 |
942 | IBM OS/2 Japanese, superset of Cp932 |
942 | C Variant of Cp942 |
943 | IBM OS/2 Japanese, superset of Cp932 and Shift-JIS |
943 | C Variant of Cp943 |
948 | OS/2 Chinese (Taiwan) superset of 938 |
949 | PC Korean |
949 | C Variant of Cp949 |
950 | PC Chinese (Hong Kong, Taiwan) |
964 | AIX Chinese (Taiwan) |
970 | AIX Korean |
1006 | IBM AIX Pakistan (Urdu) |
1025 | IBM Multilingual Cyrillic: Bulgaria, Bosnia, Herzegovinia, Macedonia (FYR) |
1026 | IBM Latin-5, Turkey |
1046 | IBM Arabic - Windows |
1097 | IBM Iran (Farsi)/Persian |
1098 | IBM Iran (Farsi)/Persian (PC) |
1112 | IBM Latvia, Lithuania |
1122 | IBM Estonia |
1123 | IBM Ukraine |
1124 | IBM AIX Ukraine |
1140 | Variant of Cp037 with Euro character |
1141 | Variant of Cp273 with Euro character |
1142 | Variant of Cp277 with Euro character |
1143 | Variant of Cp278 with Euro character |
1144 | Variant of Cp280 with Euro character |
1145 | Variant of Cp284 with Euro character |
1146 | Variant of Cp285 with Euro character |
1147 | Variant of Cp297 with Euro character |
1148 | Variant of Cp500 with Euro character |
1149 | Variant of Cp871 with Euro character |
1250 | Windows Eastern European |
1251 | Windows Cyrillic |
1253 | Windows Greek |
1254 | Windows Turkish |
1255 | Windows Hebrew |
1256 | Windows Arabic |
1257 | Windows Baltic |
1258 | Windows Vietnamese |
1381 | IBM OS/2, DOS People's Republic of China (PRC) |
1383 | IBM AIX People's Republic of China (PRC) |
33722 | IBM-eucJP - Japanese (superset of 5050) |
ASCII | American Standard Code for Information Interchange |
ISO8859_1 | ISO 8859-1, Latin alphabet No. 1 |
UnicodeBig | Sixteen-bit Unicode Transformation Format, big-endian byte order, with byte-order mark |
UnicodeBigUnmarked | Sixteen-bit Unicode Transformation Format, big-endian byte order |
UnicodeLittle | Sixteen-bit Unicode Transformation Format, little-endian byte order, with byte-order mark |
UnicodeLittleUnmarked | Sixteen-bit Unicode Transformation Format, little-endian byte order |
UTF8 | Eight-bit Unicode Transformation Format |
UTF-16 | Sixteen-bit Unicode Transformation Format, byte order specified by a mandatory initial byte-order mark |
Big5 | Big5, Traditional Chinese |
Big5_HKSCS | Big5 with Hong Kong extensions, Traditional Chinese |
Big5_Solaris | Big5 with seven additional Hanzi ideograph character mappings for the Solaris zh_TW.BIG5 locale |
EUC_CN | GB2312, EUC encoding, Simplified Chinese |
EUC_JP | JIS X 0201, 0208, 0212, EUC encoding, Japanese |
EUC_KR | KS C 5601, EUC encoding, Korean |
EUC_TW | CNS11643 (Plane 1-3), EUC encoding, Traditional Chinese |
GB18030 | Simplified Chinese, PRC standard |
GBK | GBK, Simplified Chinese |
ISCII91 | ISCII91 encoding of Indic scripts |
ISO2022CN | ISO 2022 CN, Chinese (conversion to Unicode only) |
ISO2022CN_CNS | CNS 11643 in ISO 2022 CN form, Traditional Chinese (conversion from Unicode only) |
ISO2022CN_GB | GB 2312 in ISO 2022 CN form, Simplified Chinese (conversion from Unicode only) |
ISO2022JP | JIS X 0201, 0208 in ISO 2022 form, Japanese |
ISO2022KR | ISO 2022 KR, Korean |
ISO8859_2 | ISO 8859-2, Latin alphabet No. 2 |
ISO8859_3 | ISO 8859-3, Latin alphabet No. 3 |
ISO8859_4 | ISO 8859-4, Latin alphabet No. 4 |
ISO8859_5 | ISO 8859-5, Latin/Cyrillic alphabet |
ISO8859_6 | ISO 8859-6, Latin/Arabic alphabet |
ISO8859_7 | ISO 8859-7, Latin/Greek alphabet |
ISO8859_8 | ISO 8859-8, Latin/Hebrew alphabet |
ISO8859_9 | ISO 8859-9, Latin alphabet No. 5 |
ISO8859_13 | ISO 8859-13, Latin alphabet No. 7 |
ISO8859_15_FDIS | ISO 8859-15, Latin alphabet No. 9 |
JIS0201 | JIS X 0201, Japanese |
JIS0208 | JIS X 0208, Japanese |
JIS0212 | JIS X 0208, Japanese |
JISAutoDetect | Detects and converts from Shift-JIS, EUC-JP, ISO 2022 JP (conversion to Unicode only) |
Johab | Johab, Korean |
KOI8_R | KOI8-R, Russian |
MS874 | Windows Thai |
MS932 | Windows Japanese |
MS936 | Windows Simplified Chinese |
MS949 | Windows Korean |
MS950 | Windows Traditional Chinese |
MacArabic | Macintosh Arabic |
MacCentralEurope | Macintosh Latin-2 |
MacCroatian | Macintosh Croatian |
MacCyrillic | Macintosh Cyrillic |
MacDingbat | Macintosh Dingbat |
MacGreek | Macintosh Greek |
MacHebrew | Macintosh Hebrew |
MacIceland | Macintosh Iceland |
MacRoman | Macintosh Roman |
MacRomania | Macintosh Romania |
MacSymbol | Macintosh Symbol |
MacThai | Macintosh Thai |
MacTurkish | Macintosh Turkish |
MacUkraine | Macintosh Ukraine |
SJIS | Shift-JIS, Japanese |
TIS620 | TIS620, Thai |