DB2 10.5 for Linux, UNIX, and Windows

Mappings of encoding names to effective CCSIDs for stored XML data

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.

Table 1 lists these mappings. If an encoding name is not in Table 1, the database manager returns an error.

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.

Table 1. Encoding names and effective CCSIDs
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