what is my character set?

[DBAtrix]

i know i can find it by looking in the trace file that ALTER DATABASE BACKUP CONTROLFILE TO TRACE generates... isn't there a view i can find it in? i can't remember.

thx, d.

[jmodic]

SELECT * FROM nls_database_parameters WHERE parameter= 'NLS_CHARACTERSET';

[marist89]

SQL> select value from v$nls_parameters
2 where parameter = 'NLS_CHARACTERSET';

VALUE
------------------------------
WE8ISO8859P1

[DBAtrix]

thanks! i had trouble tracking it down.

d.