9/04/2012

Oracle how to check character set

How to check character set in Oracle

One of the requirements for samePage is that the character set should be UTF-8.

You can either check with your DBA or run the following SQL to determine whether your database character set is UTF-8. 


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


It should return the value AL32UTF8.
Another option is to run the following SQL :

SELECT * FROM NLS_DATABASE_PARAMETERS

The value against NLS_CHARACTERSET should be UTF8.

No comments:

Post a Comment

Popular Posts