If you use Oracle databases in your MDM Hub implementation, you must configure the character set that you want to use. If your implementation uses mixed locale information, such as data from multiple countries with different character sets, you must configure the MDM Hub and the database to use Unicode Transfer Format (UTF-8) encoding. However, if the database contains data from a single locale, a UTF-8 database is probably not required.
Create a UTF-8 database and choose the following settings:
database character set
: AL32UTF8
national character set
: AL16UTF16
Oracle recommends to use AL32UTF8 as the database character set for Oracle 10g. For information about the previous Oracle releases, refer to the Oracle documentation.
On both the server and the client, set
NLS_LANG
to match the database character set.
For example, if you are in the United States, set NLS_LANG to the following value:
AMERICAN_AMERICA.AL32UTF8
However, if you have a Japanese implementation, set NLS_LANG to the following value:
JAPANESE_JAPAN.AL32UTF8
Ensure that you configure regional font settings on the client.
For example, if the data is from China, install Chinese fonts.
If you use a multi-byte character set, to support Unicode values, change the following setting in the C_REPOS_DB_RELEASE table: