Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Character set WE8ISO...

Re: Character set WE8ISO...

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Tue, 23 Nov 1999 17:41:13 +0100
Message-ID: <383AC3A9.C148C3E4@xlink.net>


Stephan Bojinski wrote:
>
> I created a database with a WE8ISO8859P1 character set, but seem
> unable to actually enter a-umlaut, e's with accents etc. into tables.
> For example, instead of an 'a-umlaut' in the insert statement,
> I get a 'd', and a 'v' instead of a 'o-umlaut' out of a select *
> statement.
>
> It seems that the hexadecimal numbers A, B, .., F are not supported
> here, because 'd' is encoded by '0x64' and 'a-umlaut' by '0xE4',
> and '0x76' and '0xF6' for 'v' and 'o-umlaut', respectively.
> The last number's always right, so I guess a shift to 7-bit-encoding
> occurs.
>
> What's the problem? Not a keyboard setting one, is it?
> Thanks for your help!

Set your environment variable NLS_LANG on the client machine to German_Germany.we8iso8859p1 or whatever is is appropriate to Swizerland. --
uwe.schneider_at_xlink.net Received on Tue Nov 23 1999 - 10:41:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US