To confirm that the Oracle character set definitions are set correctly and consistently, perform the following verification steps for the 32‐bit Oracle client installed on the Contenta Server machine (regardless of whether the 64‐bit Oracle server is installed on the same machine or on a different machine).
Procedure
- Log in as user sysdba.
- Issue the following SQL command in SQL*Plus:
select name, value$ value from props$ where name like
'NLS_CHARACTERSET' or name like 'NLS_NCHAR_CHARACTERSET';
- In the results, check the following:
NLS_CHARACTERSET is set to AL32UTF8
NLS_NCHAR_CHARACTERSET is set to AL16UTF16
- In the Windows registry, under
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\oracle\KEY_oracle_home_name,
check that NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8. This value must be consistent with the value set for NLS_CHARACTERSET.