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