Database character set in oracle

The database character set in oracle determines the set of characters can be stored in the database. It is also used to determine the character set to be used for object identifiers.

The database character set information is stored in the data dictionary tables named SYS.PROPS$.

You can get the character set used in the database by SYS.PROPS$ table or any other views (like database_properties/ nls_database_parameters) exist in the database. The parameter NLS_CHARACTERSET value contains the database character set name. Get it from,

SQL> select value$ from sys.props$ where name=’NLS_CHARACTERSET’;

VALUE$
——————————————————————————–
WE8MSWIN1252

SQL> select property_value from database_properties where property_name=
‘NLS_CHARACTERSET’;

PROPERTY_VALUE
——————————————————————————–
WE8MSWIN1252

SQL> select value from nls_database_parameters where parameter=’NLS_CHARACTERSET’;

VALUE
—————————————-
WE8MSWIN1252

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: