If data that you store in an XML column is in a binary application variable, or is an internally encoded XML type, the DB2® database manager examines the data to determine the encoding. If the data has an encoding declaration, the database manager maps the encoding name to a CCSID.
The normalized encoding name in the first column of Table 1 is the result of converting the encoding name to uppercase, and stripping out all hyphens, plus signs, underscores, colons, periods, and spaces. For example, ISO88591 is the normalized encoding name for ISO 8859-1, ISO-8859-1, and iso-8859-1.
Normalized encoding name | CCSID |
---|---|
437 | 437 |
646 | 367 |
813 | 813 |
819 | 819 |
850 | 850 |
852 | 852 |
855 | 855 |
857 | 857 |
862 | 862 |
863 | 863 |
866 | 866 |
869 | 869 |
885913 | 901 |
885915 | 923 |
88591 | 819 |
88592 | 912 |
88595 | 915 |
88597 | 813 |
88598 | 62210 |
88599 | 920 |
904 | 904 |
912 | 912 |
915 | 915 |
916 | 916 |
920 | 920 |
923 | 923 |
ANSI1251 | 1251 |
ANSIX341968 | 367 |
ANSIX341986 | 367 |
ARABIC | 1089 |
ASCII7 | 367 |
ASCII | 367 |
ASMO708 | 1089 |
BIG5 | 950 |
CCSID00858 | 858 |
CCSID00924 | 924 |
CCSID01140 | 1140 |
CCSID01141 | 1141 |
CCSID01142 | 1142 |
CCSID01143 | 1143 |
CCSID01144 | 1144 |
CCSID01145 | 1145 |
CCSID01146 | 1146 |
CCSID01147 | 1147 |
CCSID01148 | 1148 |
CCSID01149 | 1149 |
CP00858 | 858 |
CP00924 | 924 |
CP01140 | 1140 |
CP01141 | 1141 |
CP01142 | 1142 |
CP01143 | 1143 |
CP01144 | 1144 |
CP01145 | 1145 |
CP01146 | 1146 |
CP01147 | 1147 |
CP01148 | 1148 |
CP01149 | 1149 |
CP037 | 37 |
CP1026 | 1026 |
CP1140 | 1140 |
CP1141 | 1141 |
CP1142 | 1142 |
CP1143 | 1143 |
CP1144 | 1144 |
CP1145 | 1145 |
CP1146 | 1146 |
CP1147 | 1147 |
CP1148 | 1148 |
CP1149 | 1149 |
CP1250 | 1250 |
CP1251 | 1251 |
CP1252 | 1252 |
CP1253 | 1253 |
CP1254 | 1254 |
CP1255 | 1255 |
CP1256 | 1256 |
CP1257 | 1257 |
CP1258 | 1258 |
CP1363 | 1363 |
CP1383 | 1383 |
CP1386 | 1386 |
CP273 | 273 |
CP277 | 277 |
CP278 | 278 |
CP280 | 280 |
CP284 | 284 |
CP285 | 285 |
CP297 | 297 |
CP33722 | 954 |
CP33722C | 954 |
CP367 | 367 |
CP420 | 420 |
CP423 | 423 |
CP424 | 424 |
CP437 | 437 |
CP500 | 500 |
CP5346 | 5346 |
CP5347 | 5347 |
CP5348 | 5348 |
CP5349 | 5349 |
CP5350 | 5350 |
CP5353 | 5353 |
CP813 | 813 |
CP819 | 819 |
CP838 | 838 |
CP850 | 850 |
CP852 | 852 |
CP855 | 855 |
CP857 | 857 |
CP858 | 858 |
CP862 | 862 |
CP863 | 863 |
CP864 | 864 |
CP866 | 866 |
CP869 | 869 |
CP870 | 870 |
CP871 | 871 |
CP874 | 874 |
CP904 | 904 |
CP912 | 912 |
CP915 | 915 |
CP916 | 916 |
CP920 | 920 |
CP921 | 921 |
CP922 | 922 |
CP923 | 923 |
CP936 | 1386 |
CP943 | 943 |
CP943C | 943 |
CP949 | 970 |
CP950 | 950 |
CP964 | 964 |
CP970 | 970 |
CPGR | 869 |
CSASCII | 367 |
CSBIG5 | 950 |
CSEBCDICCAFR | 500 |
CSEBCDICDKNO | 277 |
CSEBCDICES | 284 |
CSEBCDICFISE | 278 |
CSEBCDICFR | 297 |
CSEBCDICIT | 280 |
CSEBCDICPT | 37 |
CSEBCDICUK | 285 |
CSEBCDICUS | 37 |
CSEUCKR | 970 |
CSEUCPKDFMTJAPANESE | 954 |
CSGB2312 | 1383 |
CSHPROMAN8 | 1051 |
CSIBM037 | 37 |
CSIBM1026 | 1026 |
CSIBM273 | 273 |
CSIBM277 | 277 |
CSIBM278 | 278 |
CSIBM280 | 280 |
CSIBM284 | 284 |
CSIBM285 | 285 |
CSIBM297 | 297 |
CSIBM420 | 420 |
CSIBM423 | 423 |
CSIBM424 | 424 |
CSIBM500 | 500 |
CSIBM855 | 855 |
CSIBM857 | 857 |
CSIBM863 | 863 |
CSIBM864 | 864 |
CSIBM866 | 866 |
CSIBM869 | 869 |
CSIBM870 | 870 |
CSIBM871 | 871 |
CSIBM904 | 904 |
CSIBMEBCDICATDE | 273 |
CSIBMTHAI | 838 |
CSISO128T101G2 | 920 |
CSISO146SERBIAN | 915 |
CSISO147MACEDONIAN | 915 |
CSISO2INTLREFVERSION | 367 |
CSISO646BASIC1983 | 367 |
CSISO88596I | 1089 |
CSISO88598I | 916 |
CSISOLATIN0 | 923 |
CSISOLATIN1 | 819 |
CSISOLATIN2 | 912 |
CSISOLATIN5 | 920 |
CSISOLATIN9 | 923 |
CSISOLATINARABIC | 1089 |
CSISOLATINCYRILLIC | 915 |
CSISOLATINGREEK | 813 |
CSISOLATINHEBREW | 62210 |
CSKOI8R | 878 |
CSKSC56011987 | 970 |
CSMACINTOSH | 1275 |
CSMICROSOFTPUBLISHING | 1004 |
CSPC850MULTILINGUAL | 850 |
CSPC862LATINHEBREW | 862 |
CSPC8CODEPAGE437 | 437 |
CSPCP852 | 852 |
CSSHIFTJIS | 943 |
CSUCS4 | 1236 |
CSUNICODE11 | 1204 |
CSUNICODE | 1204 |
CSUNICODEASCII | 1204 |
CSUNICODELATIN1 | 1204 |
CSVISCII | 1129 |
CSWINDOWS31J | 943 |
CYRILLIC | 915 |
DEFAULT | 367 |
EBCDICATDE | 273 |
EBCDICCAFR | 500 |
EBCDICCPAR1 | 420 |
EBCDICCPBE | 500 |
EBCDICCPCA | 37 |
EBCDICCPCH | 500 |
EBCDICCPDK | 277 |
EBCDICCPES | 284 |
EBCDICCPFI | 278 |
EBCDICCPFR | 297 |
EBCDICCPGB | 285 |
EBCDICCPGR | 423 |
EBCDICCPHE | 424 |
EBCDICCPIS | 871 |
EBCDICCPIT | 280 |
EBCDICCPNL | 37 |
EBCDICCPNO | 277 |
EBCDICCPROECE | 870 |
EBCDICCPSE | 278 |
EBCDICCPUS | 37 |
EBCDICCPWT | 37 |
EBCDICCPYU | 870 |
EBCDICDE273EURO | 1141 |
EBCDICDK277EURO | 1142 |
EBCDICDKNO | 277 |
EBCDICES284EURO | 1145 |
EBCDICES | 284 |
EBCDICFI278EURO | 1143 |
EBCDICFISE | 278 |
EBCDICFR297EURO | 1147 |
EBCDICFR | 297 |
EBCDICGB285EURO | 1146 |
EBCDICINTERNATIONAL500EURO | 1148 |
EBCDICIS871EURO | 1149 |
EBCDICIT280EURO | 1144 |
EBCDICIT | 280 |
EBCDICLATIN9EURO | 924 |
EBCDICNO277EURO | 1142 |
EBCDICPT | 37 |
EBCDICSE278EURO | 1143 |
EBCDICUK | 285 |
EBCDICUS37EURO | 1140 |
EBCDICUS | 37 |
ECMA114 | 1089 |
ECMA118 | 813 |
ELOT928 | 813 |
EUCCN | 1383 |
EUCJP | 954 |
EUCKR | 970 |
EUCTW | 964 |
EXTENDEDUNIXCODEPACKEDFORMATFORJAPANESE | 954 |
GB18030 | 1392 |
GB2312 | 1383 |
GBK | 1386 |
GREEK8 | 813 |
GREEK | 813 |
HEBREW | 62210 |
HPROMAN8 | 1051 |
IBM00858 | 858 |
IBM00924 | 924 |
IBM01140 | 1140 |
IBM01141 | 1141 |
IBM01142 | 1142 |
IBM01143 | 1143 |
IBM01144 | 1144 |
IBM01145 | 1145 |
IBM01146 | 1146 |
IBM01147 | 1147 |
IBM01148 | 1148 |
IBM01149 | 1149 |
IBM01153 | 1153 |
IBM01155 | 1155 |
IBM01160 | 1160 |
IBM037 | 37 |
IBM1026 | 1026 |
IBM1043 | 1043 |
IBM1047 | 1047 |
IBM1252 | 1252 |
IBM273 | 273 |
IBM277 | 277 |
IBM278 | 278 |
IBM280 | 280 |
IBM284 | 284 |
IBM285 | 285 |
IBM297 | 297 |
IBM367 | 367 |
IBM420 | 420 |
IBM423 | 423 |
IBM424 | 424 |
IBM437 | 437 |
IBM500 | 500 |
IBM808 | 808 |
IBM813 | 813 |
IBM819 | 819 |
IBM850 | 850 |
IBM852 | 852 |
IBM855 | 855 |
IBM857 | 857 |
IBM862 | 862 |
IBM863 | 863 |
IBM864 | 864 |
IBM866 | 866 |
IBM867 | 867 |
IBM869 | 869 |
IBM870 | 870 |
IBM871 | 871 |
IBM872 | 872 |
IBM902 | 902 |
IBM904 | 904 |
IBM912 | 912 |
IBM915 | 915 |
IBM916 | 916 |
IBM920 | 920 |
IBM921 | 921 |
IBM922 | 922 |
IBM923 | 923 |
IBMTHAI | 838 |
IRV | 367 |
ISO10646 | 1204 |
ISO10646UCS2 | 1200 |
ISO10646UCS4 | 1232 |
ISO10646UCSBASIC | 1204 |
ISO10646UNICODELATIN1 | 1204 |
ISO646BASIC1983 | 367 |
ISO646IRV1983 | 367 |
ISO646IRV1991 | 367 |
ISO646US | 367 |
ISO885911987 | 819 |
ISO885913 | 901 |
ISO885915 | 923 |
ISO885915FDIS | 923 |
ISO88591 | 819 |
ISO885921987 | 912 |
ISO88592 | 912 |
ISO885951988 | 915 |
ISO88595 | 915 |
ISO885961987 | 1089 |
ISO88596 | 1089 |
ISO88596I | 1089 |
ISO885971987 | 813 |
ISO88597 | 813 |
ISO885981988 | 62210 |
ISO88598 | 62210 |
ISO88598I | 916 |
ISO885991989 | 920 |
ISO88599 | 920 |
ISOIR100 | 819 |
ISOIR101 | 912 |
ISOIR126 | 813 |
ISOIR127 | 1089 |
ISOIR128 | 920 |
ISOIR138 | 62210 |
ISOIR144 | 915 |
ISOIR146 | 915 |
ISOIR147 | 915 |
ISOIR148 | 920 |
ISOIR149 | 970 |
ISOIR2 | 367 |
ISOIR6 | 367 |
JUSIB1003MAC | 915 |
JUSIB1003SERB | 915 |
KOI8 | 878 |
KOI8R | 878 |
KOI8U | 1168 |
KOREAN | 970 |
KSC56011987 | 970 |
KSC56011989 | 970 |
KSC5601 | 970 |
L1 | 819 |
L2 | 912 |
L5 | 920 |
L9 | 923 |
LATIN0 | 923 |
LATIN1 | 819 |
LATIN2 | 912 |
LATIN5 | 920 |
LATIN9 | 923 |
MAC | 1275 |
MACEDONIAN | 915 |
MACINTOSH | 1275 |
MICROSOFTPUBLISHING | 1004 |
MS1386 | 1386 |
MS932 | 943 |
MS936 | 1386 |
MS949 | 970 |
MSKANJI | 943 |
PCMULTILINGUAL850EURO | 858 |
R8 | 1051 |
REF | 367 |
ROMAN8 | 1051 |
SERBIAN | 915 |
SHIFTJIS | 943 |
SJIS | 943 |
SUNEUGREEK | 813 |
T101G2 | 920 |
TIS20 | 874 |
TIS620 | 874 |
UNICODE11 | 1204 |
UNICODE11UTF8 | 1208 |
UNICODEBIGUNMARKED | 1200 |
UNICODELITTLEUNMARKED | 1202 |
US | 367 |
USASCII | 367 |
UTF16 | 1204 |
UTF16BE | 1200 |
UTF16LE | 1202 |
UTF32 | 1236 |
UTF32BE | 1232 |
UTF32LE | 1234 |
UTF8 | 1208 |
VISCII | 1129 |
WINDOWS1250 | 1250 |
WINDOWS1251 | 1251 |
WINDOWS1252 | 1252 |
WINDOWS1253 | 1253 |
WINDOWS1254 | 1254 |
WINDOWS1255 | 1255 |
WINDOWS1256 | 1256 |
WINDOWS1257 | 1257 |
WINDOWS1258 | 1258 |
WINDOWS28598 | 62210 |
WINDOWS31J | 943 |
WINDOWS936 | 1386 |
XEUCTW | 964 |
XMSWIN936 | 1386 |
XUTF16BE | 1200 |
XUTF16LE | 1202 |
XWINDOWS949 | 970 |