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