Re: NLS Charactsets (the sodding things!)

"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 Fri Sep 21 2001 - 13:03:54 CDT