Setting the language in Oracle and
DB2
®
Oracle example
For example, for
Windows
™
and Oracle:
1.
Close any open Oracle sessions.
2.
Open the Registry Editor.
3.
Navigate to HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE and open the folder for your Oracle Home (ex. KEY_OraDb10g_home1).
4.
Search for the NLS_LANG setting.
5.
Make sure the last part of the value specified is UTF8. For example: AMERICAN_AMERICA.UTF8.
DB2
®
example
For example, for
DB2
®
, from the machine that is running the script and has the
DB2
®
client installed, run a
DB2
®
command window. Then run the following command:
db2set
In the output, look for the following variable/value pair:
DB2CODEPAGE=1208
If this variable is not set, run the following command
db2 db2set db2codepage=1208
Then close the session window so the change can take effect.
Copyright IBM Corporation 2012. All Rights Reserved.