Re: NLS Charactsets (the sodding things!)

Thanks Sybrand,

Slight typo on my part there!

Cheers,

Kevin
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tqn3cgao799dd1_at_news.demon.nl...
>
> "Kevin Zarzecki" <oracle_at_kevinzarzecki.com> wrote in message
> news:1001060195.28236.0.nnrp-10.c1ed11ad_at_news.demon.co.uk...
> > Hi,
> >
> > I have recently completed a fresh installation of Oracle 8.1.7 on an NT4
> > server.
> > I wanted to use the WE8ISO8859P1 character set in the database I setup
so
> I
> > changed the registry key NLS_CHAR
> > to ENGLISH.UNITED KINGDOM.WE8ISO8859P1
> > however when I installed, and loaded up the database and began inserting
> > data the £ sign appeared as a #.
> > I checked the nls parameters:
> > select * from v$nls_parameters.
> > The nls_characterset was set to US7ASCII, which I was surprised to see,
as
> I
> > have not overridden this parameter anywhere i.e. not in my init files,
and
> > no other registry settings.
> > I resolved the problem by performing an alter database character set,
and
> > setting the character set myself.
> >
> > However it is still bugging me, as to where the nls_characterset got set
> > other than from system registry.
> >
> > Can anyone shed any light on this one??
> >
> >
> > Thanks
> >
> > A very puzzled
> >
> > Kevin.
> >
> >
>
> I don't think you have set the correct registry to the correct value.
> You need to set
> NLS_LANG to
>
> ENGLISH_UNITED KINGDOM.WE8ISO8859P1
>
> You shouldn't use a dot between territory and region.
> This is why you saw US7ASCII being used.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
>
Received on Mon Sep 24 2001 - 03:52:43 CDT