On all the systems in the MDM Hub, including databases and servers, set the following environment variables:

For Oracle environments, set the following environment variable:

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

For example, the default LANG environment variable for the United States is

export LANG=en_US

Therefore, when you use UTF-8, use the following command to configure the LANG environment variable:

export LANG=en_US.UTF-8 
	 

If multiple applications are installed on a machine, and all correct locales are also installed, then you can set the correct environment variable for the profile that starts the application. If the same user profile starts multiple applications, then you can set the environment variable locally in the start-up script of the applications. This ensures that the environment variable is applied locally, and only within the context of the application process.

Usually, all LANG environment variables have the same setting, but you might use different settings. For example, if the interface language is in English but the data that you must sort is in French, then set LC_MESSAGES to en_US and LC_COLLATE to fr_FR. If you do not need to use different LANG settings, then set LC_ALL or LANG.

An application uses the following rules to determine the locale to be used:

If the LC_ALL environment variable is defined and is not null, then the application uses the value of LC_ALL.
If the appropriate component-specific environment variable, such as LC_COLLATE, is set and is not null, then the application uses the value of this environment variable.
If the LANG environment variable is defined and is not null, then the application uses the value of LANG.
If the LANG environment variable is not set or is null, then the application uses an implementation-dependent default locale.