locale -a

Locale on Linux

All UNIX operating systems except Linux have a unique value for each locale. Linux allows different values to represent the same locale. For example, “utf8,” “UTF-8,” “UTF8,” and “utf-8” represent the same locale on a Linux machine. Informatica requires that you use a specific value for each locale on a Linux machine. Make sure that you set the LANG environment variable appropriately for all Linux machines.

Locale for Oracle database clients

For Oracle database clients, set NLS_LANG to the locale that you want the database client and server to use with the login. A locale setting consists of the language, territory, and character set. The value of NLS_LANG depends on the configuration.

For example, if the value is american_america.UTF8, set the variable in a C shell with the following command:

setenv NLS_LANG american_america.UTF8

To read multibyte characters from the database, set the variable with the following command:

setenv NLS_LANG=american_america.AL32UTF8

You must set the correct variable on the Data Integration Service machine so that the Data Integration Service can read the Oracle data correctly.