Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

February 21, 2003

Want to know your Oracle character set?

I did today, but couldn't remember how to do it. All of the documentation refers to setting the character set at creation. I couldn't find the spot which showed you how to find out what it was exactly set to.

So here it is. If you are logged in with SYSDBA privilege execute the following query;

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

Posted by Andy Todd at February 21, 2003 11:59 AM

Comments

It's VALUE$ and not just value.But stil this is a good piece of information.

Posted by: Avijeet on July 18, 2003 01:58 PM

This was helpful. Thanks.

Posted by: Gary Coy on August 15, 2003 09:38 PM