Encoding Tables

The encoding tables include the following table headings:

•	Encoding Value in Pick List—This column lists all adapter Encoding field display names that are available from the field’s pick list at design-time. Note that the column lists potential values for all adapters. Your adapter likely displays a subset of these values.

•

Encoding for Runtime—Your adapter may support more encoding values than given in the adapter’s Encoding field pick list. The values in this column represent the underlying encoding used by the runtime adapter. You can type an encoding value listed in this column in the adapter’s Encoding field. The palette does not verify whether the value you provide is supported. If the value is not supported, the adapter displays an error at runtime.

•	IBM CCSID—The IBM CCSID column represents the character code set identifier (CCSID) given to the ISO code page in IBM publications.

•	Oracle NLS String—The Oracle National Language Support (NLS) string. Some multi-nation character sets require the LANGUAGE_TERRITORY prefix before the Oracle NLS_LANG value. Check with Oracle for details.

•	Description—Description of the encoding value.

Table 2 lists the ISO character sets.

 

Table 2 ISO Character Sets 

Value in Encoding Field Pick List	Encoding for Runtime	IBM CCSID	Oracle NLS String	Description
ASCII	ASCII	IBM-367	US7ASCII	7-bit ASCII
ISO-8859-1	ISO8859_1	IBM-819	language_territory.WE8ISO8859P1	ISO8859-1 (Latin-1), West European
ISO-8859-2	ISO8859_2	IBM-912	language_territory.EE8ISO8859P2	ISO8859-2 (Latin-2), East European
ISO-8859-3	ISO8859_3	IBM-913	language_territory.SE8ISO8859P3	ISO8859-3 (Latin-3), South European
ISO-8859-4	ISO8859_4	IBM-914	language_territory.NEE8ISO8859P4	ISO8859-4 (Latin-4), North European
ISO-8859-5	ISO8859_5	IBM-915	language_territory.CL8ISO8859P5	ISO8859-5, Cyrillic
ISO-8859-6	ISO8859_6	IBM-1089	ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6	ISO8859-6, Arabic
ISO-8859-7	ISO8859_7	IBM-813	GREEK_GREECE.EL8ISO8859P7	ISO8859-7, Greece
ISO-8859-8	ISO8859_8	IBM-916	HEBREW_ISRAEL.IW8ISO8859P8	ISO8859-8, Hebrew
ISO-8859-9	ISO8859_9	IBM-920	TURKISH_TURKEY.WE8ISO8859P9	ISO8859-9 (Latin-5), Turkey
ISO-8859-13	ISO8859_13	IBM-921	N/A	ISO8859-13, Baltic
ISO-8859-15	ISO8859_15 _FDIS	IBM-923	N/A	ISO8859-15 (Latin-9), Latin-1 with Euro
Shift_JIS (CP943)	CP943	IBM-943	JAPANESE_JAPAN.JA16SJIS	Japanese Shift-JIS, CP943
KSC_5601	KSC5601	IBM-949	KOREAN_KOREA.KO16KSC5601	Korean KSC-5601
Big5	Big5	IBM-1370	TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5	Traditional Chinese Big5 (with Euro Sign)
GBK	GBK	IBM-1386	SIMPLIFIED CHINESE_CHINA. ZHS16CGB231280	Simplified Chinese GBK, superset of GB2312-80
EUC-JP	EUC_JP	IBM-954	JAPANESE_JAPAN.JA16EUC	Japanese EUC
EUC-KR	EUC_KR	IBM-970	KOREAN_KOREA.KO16KSC5601	Korean EUC
EUC-CN	EUC_CN	IBM-1383	SIMPLIFIED CHINESE_CHINA. ZHS16CGB231280	Simplified Chinese EUC, compatible with GB2312-80
Shift_JIS (TIBCO)	Shift_JIS	N/A	JAPANESE_JAPAN.JA16SJIS	Variant of IBM-943, flavoring some MS-932 conversions
Shift_JIS(932)	MS932	IBM-932	JAPANESE_JAPAN.JA16SJIS	Shift_JIS encoding in MS-932 flavor
UTF8	UTF8	IBM-1208	AMERICAN_AMERICA.UTF8	Unicode Transformation Format-8
UTF16_BigEndian	UnicodeBig	N/A	N/A	UTF16 (UCS-2) Big Endian
UTF16_LittleEndian	UnicodeLittle	N/A	N/A	UTF16 (UCS-2) Little Endian

Table 3 lists the EBCDIC character sets.

 

Table 3 EBCDIC Character Sets 

Encoding Value	Encoding for Runtime	IBM CCSID	Oracle NLS String	Description
IBM-37	CP037	IBM-37	N/A	EBCDIC United States
IBM-273	CP273	IBM-273	N/A	EBCDIC Germany, Austria
IBM-277	CP277	IBM-277	N/A	EBCDIC Denmark, Norway
IBM-278	CP278	IBM-278	N/A	EBCDIC Finland, Sweden
IBM-280	CP280	IBM-280	N/A	EBCDIC Italy
IBM-284	CP284	IBM-284	N/A	EBCDIC Spain
IBM-285	CP285	IBM-285	N/A	EBCDIC UK Ireland
IBM-297	CP297	IBM-297	N/A	EBCDIC France
IBM-420	CP420	IBM-420	N/A	EBCDIC Arabic
IBM-424	CP424	IBM-424	N/A	EBCDIC Hebrew
IBM-500	CP500	IBM-500	N/A	EBCDIC Latin-1 (International)
IBM-1148	CP1148	IBM-1148	N/A	EBCDIC Latin-1 (with Euro Sign)
IBM-1047	N/A	IBM-1047	N/A	EBCDIC Open System Latin-1
IBM-1153	N/A	IBM-1153	N/A	EBCDIC Latin-2 (with Euro Sign)
IBM-1154	N/A	IBM-1154	N/A	EBCDIC Cyrillic
IBM-1156	N/A	IBM-1156	N/A	EBCDIC Baltic
IBM-1157	N/A	IBM-1157	N/A	EBCDIC Estonia
IBM-290	N/A1	IBM-290	N/A	EBCDIC Japanese Katakana (SBCS).
IBM-1159	N/A2	IBM-1159	N/A	EBCDIC Traditional Chinese (SBCS)
IBM-300	N/A3	IBM-300	N/A	EBCDIC Japanese (DBCS)
IBM-834	N/A4	BM-834	N/A	EBCDIC Korean (DBCS)
IBM-835	N/A5	IBM-835	N/A	EBCDIC Traditional Chinese (DBCS)
IBM-837	N/A	IBM-837	N/A	Forward compatible with IBM-935
IBM-930	CP930	IBM-930	N/A	EBCDIC Japanese (MBCS)
IBM-933	CP933	IBM-933	N/A	EBCDIC Korean (MBCS)
IBM-935	CP935	IBM-935	N/A	EBCDIC Simplified Chinese (MBCS)
IBM-937	CP937	IBM-937	N/A	EBCDIC Traditional Chinese (MBCS)
IBM-1390	N/A	IBM-1390	N/A	EBCDIC Japanese (MBCS) with Euro
IBM-1364	N/A	IBM-1364	N/A	EBCDIC Korean (MBCS) with Euro
IBM-1371	N/A	IBM-1371	N/A	EBCDIC Traditional Chinese (MBCS) with Euro

---

1

Forward compatible with CP930

2

Forward compatible with CP937

3

Forward compatible with CP930

4

Forward compatible with CP933

5

Forward compatible with CP937

Table 4 lists the Microsoft Windows character sets.

Table 4 Microsoft Windows Character Sets 

Encoding Value	Encoding for Runtime	IBM CCSID	Oracle NLS Encoding	Description
Windows Latin-1	CP1252	IBM-1252	language_territory.WE8MSWIN1252	Windows Latin-1 with Euro Sign
Windows Latin-2	CP1250	IBM-1250	language_territory.EE8MSWIN1250	Windows Latin-2 with Euro Sign
Windows Cyrillic	CP1251	IBM-1251	language_territory.CL8MSWIN1251	Windows Cyrillic with Euro Sign
Windows Greek	CP1253	IBM-1253	GREEK_GREECE.EL8MSWIN1253	Windows Greek with Euro Sign
Windows Turkish	CP1254	IBM-1254	TURKISH_TURKEY.TR8MSWIN1254	Windows Turkish with Euro Sign
Windows Hebrew	CP1255	IBM-1255	HEBREW_ISRAEL.IW8MSWIN1255	Windows Hebrew with Euro Sign
Windows Arabic	CP1256	IBM-1256	ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256	Windows Arabic with Euro Sign
Windows Baltic	CP1257	IBM-1257	language_territory.BLT8MSWIN1257	Windows Baltic with Euro Sign