Setting the language in Oracle and DB2®

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.