How to check Oracle database character set?

Just a quick one.

If you need to check what is the running database character set…

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

HTH,
Pasi

Tags: , ,

This entry was posted on Monday, April 11th, 2011 at 11:48 and is filed under NLS, Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

 

Leave a Reply