Documentation Center

Verifying Oracle character set definitions

To confirm that the Oracle character set definitions are set correctly and consistently, perform the following verification steps.

Procedure

  1. Log in as user oracle.
  2. 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';

  3. In the results, check the following:
    • NLS_CHARACTERSET is set to AL32UTF8
    • NLS_NCHAR_CHARACTERSET is set to AL16UTF16
  4. In pdm.cshrc.ora, check that the environment variable NLS_LANG is set to American_America.AL32UTF8.