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 -> Character set WE8ISO...

Character set WE8ISO...

From: Stephan Bojinski <sbojinsk_at_geo.unizh.ch>
Date: Tue, 23 Nov 1999 11:10:21 +0100
Message-ID: <383A680D.40B739CF@geo.unizh.ch>


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!


attached mail follows:



I created a database with a WE8ISO8859P1 character set, but seem to be 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.

What's the problem? Not a keyboard setting one, is it?



Stephan Bojinski
Remote Sensing Laboratories Dept. of Geography University of Zurich
Winterthurerstrasse 190     CH - 8057 Zuerich             Switzerland
sbojinsk@geo.unizh.ch                http://www.geo.unizh.ch/~sbojinsk

phone: +411 635 52 49                            fax: +41 1 635 68 46
___________________________________________________________________




Received on Tue Nov 23 1999 - 04:10:21 CST

Original text of this message

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