Linux

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.

ee
Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s