Re: Special Characters Created on a UNIX system with HP Terminal on US7ASCII

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 19 Jul 2007 10:23:40 +0200
Message-ID: <f7n723$vit$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Martin T. wrote:
>

>>From the "Globalization Support Guide":

> US7ASCII / U.S. 7-bit ASCII / US / Bits: 7 / ASCII
>
> So you are telling us that you used US7ASCII to store German umlauts?
> This is just wrong. US7ASCII is just 0x00 -> 0x7F but the characters
> you are talking about are 0x80 -> 0xFF and so cannot be correctly
> stored in an US7ASCII character set column.
>

Simply not true - Oracle *always* stores bytes. Very dangerous assumption, that has cost a lot of money already.

Same with the ability to "store the Euro-character in WE8ISO8859P1" - it works with no problem at all.

Basically, because you do not store the euro symbol, but a code. It is up to the client to display this code correctly as '€'. If the client is thinking the code belongs to '¢' - it will display that.
If the client does not know how to display, the convention is to display an inverted question mark.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGnx+LLw8L4IAs830RAnrUAKCNSrzGaSZEiR0iZHowX3gFZRgs3QCbBaB4 yKNDw5kxtZ9IsJqU4BCxMiE=
=wXzT
-----END PGP SIGNATURE----- Received on Thu Jul 19 2007 - 03:23:40 CDT