How to check character set in Oracle

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

VALUE$ -------------------------------- AL32UTF8

Or

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE parameter = 'NLS_CHARACTERSET';


PARAMETER VALUE --------------------------------------- NLS_CHARACTERSET AL32UTF8
Comments