Oracle: Check database charcterset:

To check the current characterset use the following queries:

SELECT *
FROM   NLS_DATABASE_PARAMETERS
where  parameter like 'NLS_%';

SELECT value$
FROM sys.props$
WHERE name like  'NLS_%';