There is NLS_CHARACTERSET both in PROPS$ and V$NLS_PARAMETERS!
1 select * from v$nls_parameters
2* where parameter like '%CHARACTERSET'
PARAMETER VALUE
------------------------- -------------------------
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
In article <94p1fv$k2g$1_at_s1.read.news.oleane.net>,
"Michel Cadot" <micadot_at_netcourrier.com> wrote:
> Whoops! Sorry, too fast answer!
> v$nls_parameters gives you your current nls parameters
> except NLS_CHARACTERSET.
>
> You can get it in HKLM\Software\Oracle\NLS_LANG on NT,
> or with !echo $NLS_LANG with Unix/Sql*Plus,
> or with getenv funtion in C...
>
> I don't know if it's possible with pure SQL.
>
> --
> Regards
> Michel
>
> "Thomas Schwickert" <thomas.schwickert_at_itellium.com> a écrit dans le
message news:
> 94ost0$sb$1_at_nnrp1.deja.com...
> > In article <94op2n$e9r$1_at_s1.read.news.oleane.net>,
> > "Michel Cadot" <micadot_at_netcourrier.com> wrote:
> > > You can find your current settings of nls parameters in
v$nls_parameters.
> > >
> > > --
> > > Have a nice day
> > > Michel
> > >
> >
> > Hi Michael,
> >
> > thanks for your reply, but I think, you are wrong.
> > With v$nls_parameters, you get NLS_CHARACTERSET,
> > which is the characterset of the database, not the one, your
> > client is using in fact
> > (just set NLS_LANG=america_american.us7ascii, use sqlplus
> > and query v$nls_parameters, it will show you the characterset
> > of the database)
> >
> > Anyway, thanks
> > Thomas
> >
> > Thomas Schwickert Phone: +49 69 - 404
8093
> > Itellium System & Services GmbH Fax: +49 69 - 404 5561
> > 60386 Frankfurt
> > Germany
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Sent via Deja.com
http://www.deja.com/
Received on Thu Jan 25 2001 - 16:41:10 CST
