Verify Locale Settings and Code Page Compatibility
The code pages for application services must be compatible with code pages in the domain.
Verify and configure the locale settings and code pages:
- Verify that the domain configuration database is compatible with the code pages of the application services that you create in the domain.
- The Service Manager synchronizes the list of users in the domain with the list of users and group in each application service. If a user name in the domain has characters that the code page of the application service does not recognize, characters do not convert correctly and inconsistencies occur.
- Verify that the locale settings on machines that access the Administrator tool and the Informatica client tools are compatible with code pages of repositories in the domain.
- If the locale setting is not compatible with the repository code page, you cannot create an application service.
Configure Locale Environment Variables
Verify that the locale setting is compatible with the code page for the repository. If the locale setting is not compatible with the repository code page, you cannot create an application service.
Use LANG, LC_CTYPE, or LC_ALL to set the UNIX code page.
Different UNIX operating systems require different values for the same locale. The value for the locale variable is case sensitive.
Use the following command to verify that the value for the locale environment variable is compatible with the language settings for the machine and the type of code page you want to use for the repository:
locale -a
The command returns the languages installed on the UNIX operating system and the existing locale settings.
Set the following locale environment variables:
- 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.