Setting the NLS_LANG Environment Variable for Oracle Databases

Follow this procedure to set the NLS_LANG environment variable for Oracle databases.

To set the NLS_LANG environment variable for Oracle databases

1. Determine the NLS_LANG value.
   1. In the data warehouse database, run the command
   SELECT * FROM V$NLS_PARAMETERS
   2. Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
      For example: American_America.UTF8
2. For Windows:
   1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
   2. In System variables section, click New.
   3. In the Variable Name field, enter NLS_LANG.
   4. In the Variable Value field, enter the NLS_LANG value that was returned in Step 1.
      The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
      For example: American_America.UTF8.
3. For UNIX, set the variable as shown below:
   setenv NLS_LANG <NLS_LANG>
   For example: setenv NLS_LANG American_America.UTF8.
   If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set
   NLS_LANG <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1
   CAUTION:  Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly.
4. Reboot the machine after creating the variable.