Mappings of CCSIDs to encoding names for textual XML output data
As part of an implicit or explicit XMLSERIALIZE operation, Db2 might add an encoding declaration at the beginning of textual XML output data.
<?xml version="1.0" encoding="encoding-name"?>
In general, the character set identifier in the encoding declaration describes the encoding of the characters in the output string. For example, when XML data is serialized to the CCSID that corresponds to the target application data type, the encoding declaration describes the target application variable CCSID. An exception is the case where the application performs an explicit XMLSERIALIZE function with INCLUDING XMLDECLARATION. When you specify INCLUDING XMLDECLARATION, the database manager generates an encoding declaration for UTF-8. If the target data type is a CLOB or DBCLOB type, additional code page conversion might occur, which can make the encoding information inaccurate. If the data is further parsed in the application, data corruption can result.
Where possible, Db2 chooses the IANA registry name for the CCSID, as prescribed by the XML standard.
- If the CCSID has one to three digits, the generated encoding name is IBM®nnn, where nnn is the CCSID, which is left-padded with zeroes for a one-digit or two-digit CCSID.
- If the CCSID has four to five digits, the generated encoding name is IBMnnnnn, where nnnnn is the CCSID, which is left-padded with a zero for a four-digit CCSID.
CCSID | Encoding name |
---|---|
37 | IBM037 |
273 | IBM273 |
277 | IBM277 |
278 | IBM278 |
280 | IBM280 |
284 | IBM284 |
285 | IBM285 |
297 | IBM297 |
367 | US-ASCII |
420 | IBM420 |
423 | IBM423 |
424 | IBM424 |
437 | IBM437 |
500 | IBM500 |
808 | IBM808 |
813 | ISO-8859-7 |
819 | ISO-8859-1 |
838 | IBM-Thai |
850 | IBM850 |
852 | IBM852 |
855 | IBM855 |
857 | IBM857 |
858 | IBM00858 |
862 | IBM862 |
863 | IBM863 |
864 | IBM864 |
866 | IBM866 |
867 | IBM867 |
869 | IBM869 |
870 | IBM870 |
871 | IBM871 |
872 | IBM872 |
874 | TIS-620 |
878 | KOI8-R |
901 | ISO-8859-13 |
902 | IBM902 |
904 | IBM904 |
912 | ISO-8859-2 |
915 | ISO-8859-5 |
916 | ISO-8859-8-I |
920 | ISO-8859-9 |
921 | ISO-8859-13 |
922 | IBM922 |
923 | ISO-8859-15 |
924 | IBM00924 |
932 | Shift_JIS |
943 | Windows-31J |
949 | EUC-KR |
950 | Big5 |
954 | EUC-JP |
964 | EUC-TW |
970 | EUC-KR |
1004 | Microsoft-Publish |
1026 | IBM1026 |
1043 | IBM1043 |
1047 | IBM1047 |
1051 | hp-roman8 |
1089 | ISO-8859-6 |
1129 | VISCII |
1140 | IBM01140 |
1141 | IBM01141 |
1142 | IBM01142 |
1143 | IBM01143 |
1144 | IBM01144 |
1145 | IBM01145 |
1146 | IBM01146 |
1147 | IBM01147 |
1148 | IBM01148 |
1149 | IBM01149 |
1153 | IBM01153 |
1155 | IBM01155 |
1160 | IBM-Thai |
1161 | TIS-620 |
1162 | TIS-620 |
1163 | VISCII |
1168 | KOI8-U |
1200 | UTF-16 |
1202 | UTF-16 |
1204 | UTF-16 |
1208 | UTF-8 |
1232 | UTF-32 |
1234 | UTF-32 |
1236 | UTF-32 |
1250 | windows-1250 |
1251 | windows-1251 |
1252 | windows-1252 |
1253 | windows-1253 |
1254 | windows-1254 |
1255 | windows-1255 |
1256 | windows-1256 |
1257 | windows-1257 |
1258 | windows-1258 |
1275 | MACINTOSH |
1363 | KSC_5601 |
1370 | Big5 |
1381 | GB2312 |
1383 | GB2312 |
1386 | GBK |
1392 | GB18030 |
4909 | ISO-8859-7 |
5039 | Shift_JIS |
5346 | windows-1250 |
5347 | windows-1251 |
5348 | windows-1252 |
5349 | windows-1253 |
5350 | windows-1254 |
5351 | windows-1255 |
5352 | windows-1256 |
5353 | windows-1257 |
5354 | windows-1258 |
5488 | GB18030 |
8612 | IBM420 |
8616 | IBM424 |
9005 | ISO-8859-7 |
12712 | IBM424 |
13488 | UTF-16 |
13490 | UTF-16 |
16840 | IBM420 |
17248 | IBM864 |
17584 | UTF-16 |
17586 | UTF-16 |
62209 | IBM862 |
62210 | ISO-8859-8 |
62211 | IBM424 |
62213 | IBM862 |
62215 | ISO-8859-8 |
62218 | IBM864 |
62221 | IBM862 |
62222 | ISO-8859-8 |
62223 | windows-1255 |
62224 | IBM420 |
62225 | IBM864 |
62227 | ISO-8859-6 |
62228 | windows-1256 |
62229 | IBM424 |
62231 | IBM862 |
62232 | ISO-8859-8 |
62233 | IBM420 |
62234 | IBM420 |
62235 | IBM424 |
62237 | windows-1255 |
62238 | ISO-8859-8-I |
62239 | windows-1255 |
62240 | IBM424 |
62242 | IBM862 |
62243 | ISO-8859-8-I |
62244 | windows-1255 |
62245 | IBM424 |
62250 | IBM420 |