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 |