将编码名映射至已存储的 XML 数据的有效 CCSID
每个编码名称都对应一个特定的CCSID。
Db2 检查二进制应用程序变量或内部编码的XML类型中的数据，以确定编码，然后将数据存储在XML列中。 如果数据有编码声明， Db2 会将编码名称映射到CCSID。
下表列出了这些映射。 如果编码名称不在表中， Db2 将返回错误。
下表第一列中的标准化编码名称是将编码名称转换为大写，并删除所有连字符、加号、下划线、冒号、句号和空格后的结果。 例如，ISO88591 是 ISO 8859-1、ISO-8859-1 和 iso-8859-1 的规范化编码名。
| 规范化编码名 | 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 |
| 缺省值 | 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 | 5346 |
| WINDOWS1251 | 5347 |
| WINDOWS1252 | 5348 |
| WINDOWS1253 | 5349 |
| WINDOWS1254 | 5350 |
| WINDOWS1255 | 5351 |
| WINDOWS1256 | 5352 |
| WINDOWS1257 | 5353 |
| WINDOWS1258 | 5354 |
| WINDOWS28598 | 62210 |
| WINDOWS31J | 943 |
| WINDOWS936 | 1386 |
| XEUCTW | 964 |
| XMSWIN936 | 1386 |
| XUTF16BE | 1200 |
| XUTF16LE | 1202 |
| XWINDOWS949 | 970 |