Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Character set WE8ISO...
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