For Unica Interact only: Changing language setting in Oracle and DB2®

Before you create views or materialized views for Unica Interact, verify that the language setting for the computer where you run the lookup_create SQL script is enabled for UTF-8 en.

About this task

To change the language setting, complete either step 1 or step 2 depending on your database type.


  1. For Oracle databases, complete the following steps:
    1. Close all open Oracle sessions.
    2. Open the Registry Editor.
    3. Browse to HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE and open the folder for your Oracle Home, for example, 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.
  2. For DB2® databases, complete the following steps:
    1. From the computer that is running the script and has the DB2® client installed, open a DB2® command window.
    2. Run the following command:
    3. In the output, look for the following variable-value pair:
    4. If the DB2CODEPAGE=1208 variable is not set, run the following command:
      db2 db2set db2codepage=1208
    5. Close the session window for the change to take effect.