Re: How to check characterset on database

From: <susil99_at_my-deja.com>
Date: Wed, 05 Jan 2000 20:00:17 GMT
Message-ID: <8507s6$cto$1@nnrp1.deja.com>

use: select substr(name,1,15), substr(value$,1,15) from sys.props$; This will give you NLS character set and database character set defined for the db server.

In article <3872F292.646AF075_at_allpublic.ch>, Palani <palani_at_allpublic.ch> wrote:
> Hi,
>
> select parameter, value from v$nls_parameters
> where parameter = 'NLS_CHARACTERSET';
>
> Palani
>
> Henrik Meldgaard Frisk wrote:
> >
> > 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 14:00:17 CST