Sunday, 27 January 2013

How to check character set in Oracle



You can either check with your DBA or run the following SQL to determine your database character set.

SQL> SELECT value FROM NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';

VALUE
-------------------------------------------------------------------------------------
UTF8

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

VALUE$
--------------------------------------------------------------------------------------
UTF8