To find out the current DB charset of an Oracle database:
How to check character set in Oracle:
SELECT value$ FROM sys.props$ WHERE name = ‚NLS_CHARACTERSET‘ ;
Alternate source:
SELECT *
FROM v$nls_parameters
WHERE parameter LIKE ‚%CHARACTERSET‘
To find out the current DB charset of an Oracle database:
How to check character set in Oracle:
SELECT value$ FROM sys.props$ WHERE name = ‚NLS_CHARACTERSET‘ ;
Alternate source:
SELECT *
FROM v$nls_parameters
WHERE parameter LIKE ‚%CHARACTERSET‘