Oracle

26
Jun

Oracle. Character set

Posted by eugene as Oracle

For getting the current encoding, you can use the following queries:

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
SELECT * FROM NLS_DATABASE_PARAMETERS

The meaning of the encoding is contained in the NLS_CHARACTERSET field.