Run an SQL command and check the registry to very that the Oracle character set definitions are set correctly and consistently.
Procedure
- Run the following commands while logged in as user
oracle, entering your password if required:
sqlplus /nolog
connect /as sysdba
- From the SQL Plus prompt, enter the following:
select name, value$ value from props$ where name like
'NLS_CHARACTERSET' or name like 'NLS_NCHAR_CHARACTERSET';
- Verify the following in the results:
- Verify that
NLS_CHARACTERSET is set to AL32UTF8.
- Verify that
NLS_NCHAR_CHARACTERSET is set to AL16UTF16.
- From your Windows registry editor, navigate to , where ORACLEHOMENAME is the name of your Oracle home.
- Verify that
NLS_LANG in this location has a value that corresponds to the value for NLS_CHARACTERSET, that is, AMERICAN_AMERICA.AL32UTF8.