To confirm that the Oracle character set definitions are set correctly and consistently, perform the following verification steps.
Procedure
- Log in as user oracle.
- 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 pdm.cshrc.ora, check that the environment variable
NLS_LANG is set to American_America.AL32UTF8.