Oracle Code Page Settings
Both the NLS_characterset and NLS_LANG environment variables need to be set correctly.
Additionally, the Oracle character set for the database needs to be set correctly depending on the language used as listed in this table:
Tier |
Language |
Code Page Setting |
---|---|---|
1 |
English |
WE8MSWIN1252 |
1 |
French |
WE8MSWIN1252 |
1 |
German |
WE8MSWIN1252 |
1 |
Italian |
WE8MSWIN1252 |
1 |
Spanish |
WE8MSWIN1252 |
1 |
Portuguese |
WE8MSWIN1252 |
1 |
Japanese |
JA16SJIS |
2 |
Danish |
WE8MSWIN1252 |
2 |
Dutch |
WE8MSWIN1252 |
2 |
Finnish |
WE8MSWIN1252 |
2 |
Norwegian |
WE8MSWIN1252 |
2 |
Swedish |
WE8MSWIN1252 |
2 |
Korean |
KO16MSWIN949 |
2 |
Traditional Chinese |
ZHT16MSWIN950 |
2 |
Simplified Chinese |
ZHS16GBK |
3 |
Arabic |
AR8MSWIN1256 |
3 |
Czech |
EE8MSWIN1250 |
3 |
Hungarian |
EE8MSWIN1250 |
3 |
Polish |
EE8MSWIN1250 |
3 |
Greek |
EL8MSWIN1253 |
3 |
Russian |
CL8MSWIN1251 |
3 |
Turkish |
TR8MSWIN1254 |