DB2 for IBM i Code Page Settings

The DB2 for IBM i character set (CCSID) for the database needs to be set correctly depending on the language used as listed in this table:

Tier

Language

DB2 for IBM i (CCSID)

1

English

37

1

French

37

1

German

37

1

Italian

37

1

Spanish

37

1

Portuguese

37

1

Japanese

939

2

Danish

37

2

Dutch

37

2

Finnish

37

2

Norwegian

37

2

Swedish

37

2

Korean

933

2

Traditional Chinese

937

2

Simplified Chinese

935

3

Arabic

N\A

3

Czech

870

3

Hungarian

870

3

Polish

870

3

Greek

875

3

Russian

1025

3

Turkish

1026