Database Character set ?

[vr76413]

Hello all..

PArdon me if this question is answered before...

But i have a 901 DB. How do we find out the character set of the database ?...also what is the default ?

thanks
Ron

[anujdutt]

For NLS_CHARACTER SET you can see the query v$NLS_PARAMETERS dynamic view.

For database character set run this command.

alter database backup controlfile to trace;

The trace file generated will have the command to recreate controlfile and also information about the DATABASE CHARACTER SET.