As Eric Diehl wrote: select from sys.props$. Don't know another view for the
characterset.
Alternatively you can read the trace file created by alter database backup
controlfile to trace;
V$PARAMETER also shows database settings for other NLS-parameters.

Anker advised a query on V$NLS_PARAMETERS but that view shows the CURRENT
settings, not the database values. Configuration of the client (windows
registry, variables) influences these settings very much.
SQL*Net takes care of the translation to the client character set if it
differs from the database set.

----- Original Message -----
From: Shepard, Wade <[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] Thursday, May 30, 2002 8:23 PM
Subject: How Do I determine Database character set?


|
|
| I just recently did the following command
|
| SVRMGR> ALTER DATABASE CHARACTER SET UTF8;
|
| I know there is a V$ for NLS_CHARACTER SET is there on for Database
| Character set?
|
|
| --------
| Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these
terms:http://www.lazydba.com/legal.html
|
|

Oracle LazyDBA home page