Re: get the character set of a database

would this SQL statement tell me the "National character set" or the default character set ?
I think these two are different.

thank you
Jennifer C

"Luggy" <dave_at_oracle-consultant.co.uk> ¼¶¼g©ó¶l¥ó news:92f6ln$293$1_at_nnrp1.deja.com...
> Hi Jennifer,
>
> This'll do it...
>
> select nls_characterset from nls_database_parameters;
>
> You may also be interested in nls_instance_parameters and
> nls_session_parameters.
>
> HTH,
>
> Dave.
>
>
>
> In article <92f4da$qkb$1_at_news.seed.net.tw>,
> "Jennifer Chang" <jchang_at_uxb2b.com> wrote:
> > I want to get the character set setting of a database
> > which table or view should i query ?
> >
> > thank you
> >
> > Jennifer Chang
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 28 2000 - 19:09:58 CST