IBM Support

Supported character sets

Product Documentation


Abstract

This document contains the character sets supported with your Optim solutions.

Content

To see the character sets for a database, click on it in the table below.

Tabs by platform

DB2® for Linux, UNIX, and Windows

DB2 for z/OS 

DB2 for Linux, UNIX, and Windows

The following single byte character sets are supported:

Character Set Description

437

English

850

International Multilingual

860

Portuguese

863

Canadian French

865

Nordic

1250

Eastern European

1251

Cyrillic

1252

Latin 1

1253

Greek

1254

Turkish

1255

Hebrew

1256

Arabic

1257

Baltic

The following multi byte character sets are supported:

Character Set Description

932

IBM SJIS

936

Windows Simplified Chinese

9431

IBM SJIS for open environment

949

Korean (KS Code 5601-89)-including 1880 UDC

950

IBM Chinese Big5

954

IBM EUC Japanese

964

IBM-eucTW Traditional Chinese

970

Korean (EUC)

1363

Korean

1383

IBM-eucCN Simplified Chinese

1386

IBM Simplified Chinese

1For code page 943 there are two DB2-specific ICU converters:

  • The default converter is installed when you install your Optim solution. this converter represents the code points reflected in the default DB2 server/client installation.
  • An alternate converter represents the code points used when the alternate CP 943 converter is used within DB2 server/client.

The commands to use the alternate CP 943 ICU converter are:

        cd rt
        cd bin
        copy opmicuda.dat opmicud2.dat
        copy opmicuda.als opmicud2.als

The trace entry reflects the use of the db2luw-943-alt converter.

The following Unicode character sets are supported:

Character Set Character Set Character Set

437

949

1252

850

950

1363

860

964

1370

863

970

1383

865

1200

1386

865

1208

DB2® for z/OS

 

The following single byte character sets are supported:

Code Page Description

037

Latin 1 (IBM EBCDIC U.S./Canada)

273

Latin 1 (IBM EBCDIC Austria/Germany)

277

Latin 1 (IBM EBCDIC Denmark/Norway)

278

Latin 1 (IBM EBCDIC Finland/Sweden)

280

Latin 1 (IBM EBCDIC Italy)

284

Latin 1 (IBM EBCDIC Spain)

285

Latin 1 (IBM EBCDIC United Kingdom)

297

Latin 1 (IBM EBCDIC France)

500

Latin 1 (IBM EBCDIC International)

871

Latin 1 (IBM EBCDIC Iceland)

Support for multibyte characters in DB2 for z/OS has the following limitations:

  • DB2 for Linux, UNIX, and Windows v9.7 FixPack 5 or higher is required on the Optim workstation or server.
  • Processing of CLOB and DBCLOB data is not supported in an ASCII or Unicode tablespace.

The following multi byte character sets are supported:

border="1"
Code Page Description

IBM-930

Japanese (Katakana) Extended with 4370 UDC.
SBCS:IBM-290 + DBCS:IBM-300
SBCS-CCSID:290 + DBCS-CCSID:300

IBM-933

Korean Extended with 1880 UDC.
SBCS:IBM-833 + DBCS:IBM-834
SBCS-CCSID:833 + DBCS-CCSID:834

IBM-935

PRC, Simplified Chinese Extended with 188 UDC.
SBCS:IBM-836 + DBCS:IBM-837
SBCS-CCSID:836 + DBCS-CCSID:837

IBM-937

Taiwan Traditional Chinese with 6204 UDC.
SBCS:IBM-037 + DBCS:835
SBCS-CCSID:28709 + DBCS-CCSID:835

IBM-939

Japanese (Latin) Extended with 4370 UDC.
SBCS-CP:IBM-1027 + DBCS-CP:IBM-300
SBCS-CCSID:1027 + DBCS-CCSID:300

IBM-1364

Korean Extended with 11,172 full hangul.
SBCS:IBM-833 + DBCS:IBM-834
SBCS-CCSID:13121 + DBCS-CCSID:4930

IBM-1388

Simplified Chinese - GB18030 with UDCs and Uygur.
SBCS:IBM-836 + DBCS:IBM-837
SBCS-CCSID:13124 + DBCS-CCSID:4933

IBM-1390

Japanese (Katakana) Extended with euro and UDC 6205.
SBCS:IBM-290 + DBCS:IBM-300
SBCS-CCSID:8482 + DBCS-CCSID:16684

IBM-1399

Japanese (Latin) Extended with euro and 6205 UDC.
SBCS:IBM-1027 + DBCS:IBM-300
SBCS-CCSID:5123 + DBCS-CCSID:16684

IBM-5026

Subset of IBM-930 with 1880 UDC.
SBCS:IBM-290 + DBCS:IBM-300
SBCS-CCSID:290 + DBCS-CCSID:4396

IBM-5035

Subset of IBM-939 with 1880 UDC.
SBCS:IBM-1027 + DBCS:IBM-300
SBCS-CCSID:1027 + DBCS-CCSID:4396

The following Unicode character sets are supported:

Character Set Character Set Character Set

437

863

1208

850

865

1252

860

1200

[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Client components","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"9.1;8.1;11.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 July 2021

UID

swg27021866

Page Feedback