Re: get the character set of a database

Oops,
correction - the one I wanted to inquire should be "Character set" not the default character set.
the one you set when creating a database by Oracle database configuration assistant under Win2000

thank you.
Jennifer

"Jennifer Chang" <jchang_at_uxb2b.com> ¼¶¼g©ó¶l¥ó news:92go7i$c3r$1_at_news.seed.net.tw...
> 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:20:16 CST