Re: NLS Charactsets (the sodding things!)

hi,

Kevin Zarzecki wrote:
>
> 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.
>

CREATE DATABASE xxx CHARACTER SET WE8ISO8859P1 ...

afaik the default is US7ASCII.

ciao
andreas

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de