The IBM code-set of the database and OS Locale needs to be set correctly for the language used as listed in this table:
Tier |
Language |
DB2 for Linux, Windows, and UNIX Code-Set |
---|---|---|
1 |
English |
1252 |
1 |
French |
1252 |
1 |
German |
1252 |
1 |
Italian |
1252 |
1 |
Spanish |
1252 |
1 |
Portuguese |
1252 |
1 |
Japanese |
IBM-943 |
2 |
Danish |
1252 |
2 |
Dutch |
1252 |
2 |
Finnish |
1252 |
2 |
Norwegian |
1252 |
2 |
Swedish |
1252 |
2 |
Korean |
1363 |
2 |
Traditional Chinese |
big5 |
2 |
Simplified Chinese |
GBK |
3 |
Arabic |
1256 |
3 |
Czech |
1250 |
3 |
Hungarian |
1250 |
3 |
Polish |
1250 |
3 |
Greek |
1253 |
3 |
Russian |
1251 |
3 |
Turkish |
1254 |