DB2 10.5 for Linux, UNIX, and Windows

Mappings of CCSIDs to encoding names for serialized XML output data

As part of an implicit or explicit XMLSERIALIZE operation, the DB2® database manager might add an encoding declaration at the beginning of serialized XML output data.

That declaration has the following form:

<?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, the DB2 database manager chooses the IANA registry name for the CCSID, as prescribed by the XML standard.
Table 1. CCSIDs and corresponding encoding names
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 IBM921
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-16BE
1202 UTF-16LE
1204 UTF-16
1208 UTF-8
1232 UTF-32BE
1234 UTF-32LE
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-16BE
13490 UTF-16LE
16840 IBM420
17248 IBM864
17584 UTF-16BE
17586 UTF-16LE
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