HOW TO CHECK DB CHARACTER SET? 1

[viztek]

Hi,

tell me how can i check what character set my db has.

tell me sql command or solme other way to know that.

thanks,
Viztek

 

[Shantha]

SELECT * FROM V$NLS_PARAMETERS;
or
select * from nls_database_parameters;

NLS_CHARACTERSET record will display the character set of the database.
Talent is what you possess;
genius is what possesses you