Wednesday 15 May 2013

how to check nls_characterset parameter of database

SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET';
VALUE$
--------------------------------------------------------------------------------
WE8ISO8859P1

SQL>  SELECT value$ FROM sys.props$ WHERE name = 'NLS_NCHAR_CHARACTERSET';
VALUE$
--------------------------------------------------------------------------------
AL16UTF16

No comments: