Check Your Oracle 11g Code Page Values

15 Mar 2013

Run the following query:

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT parameter, VALUE  
FROM nls_database_parameters  
WHERE parameter IN (  
  'NLS_CHARACTERSET',  
  'NLS_NCHAR_CHARACTERSET',  
  'NLS_TERRITORY',  
  'NLS_LANGUAGE',  
  'NLS_SORT'  
)  
ORDER BY parameter;

Typical output will be something like this:

PARAMETER               VALUE
----------------------  ---------
NLS_CHARACTERSET        AL32UTF8   
NLS_LANGUAGE            AMERICAN   
NLS_NCHAR_CHARACTERSET  AL16UTF16  
NLS_SORT                BINARY     
NLS_TERRITORY           AMERICA

NLS_LANG, which summarizes the above settings, will look something like this:

NLS_LANG=american_america.AL32UTF8