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