NLS Charactsets (the sodding things!)

From: Kevin Zarzecki <oracle_at_kevinzarzecki.com>
Date: Fri, 21 Sep 2001 09:16:14 +0100
Message-ID: <1001060195.28236.0.nnrp-10.c1ed11ad@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. Received on Fri Sep 21 2001 - 03:16:14 CDT