Re: How to check characterset on database

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 5 Jan 2000 18:16:52 +0100
Message-ID: <84vua6$2n7s$1@news6.isdnet.net>

You can get the character sets used in the database with the query:

v815> select parameter, value from nls_database_parameters where parameter like '%CHARACTERSET%';

PARAMETER                      VALUE
------------------------------ ------------------------------
NLS_CHARACTERSET               WE8ISO8859P1
NLS_NCHAR_CHARACTERSET         WE8ISO8859P1

2 rows selected.

--
Have a nice day
Michel

Henrik Meldgaard Frisk <hfr_at_bang-olufsen.dk> a écrit dans le message : 84urfv$irr$1_at_news.inet.tele.dk...
> Hi
>
> I have a Oracle8.0.4 Unix database where I want to see what the characterset
> is set to. How and where can I check that?
> I have all the administrators tools on me Windows NT, but I can't find the
> characterset.
> I guess it is posible to check it from a Unix terminal too, but again. I
> don't no how.
>
> Henrik
>
>
Received on Wed Jan 05 2000 - 11:16:52 CST