RE: US7ASCII / French Character

  • From: "Vergara, Michael (TEM)" <mvergara@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 31 Aug 2004 08:04:45 -0700

Ooh...that's much better than my current example.  I've
been using a name from our database - "Mu=F1oz" (the '=F1'
character here is an 'n' with a tilde '~').  This name
becomes "Muqoz" after a character set conversion from
US7ASCII to WE8ISO8859P1.

Cheers,
Mike


-----Original Message-----
From: Michael Thomas [mailto:mhthomas@xxxxxxxxx]
Sent: Tuesday, August 31, 2004 6:43 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: US7ASCII / French Character


Hi,

Its very interesting with some data. For example,=20
the micro (u looking character), if stored in
USASCII7, gets converted to a number 6 in UTF-8
(without conversion and across db_links). Therefore,=20
1 micro gram (USASCII7) becomes 16 grams (UTF-8).=20
Much more fun than ?nre?d?ble st?ff.

Oracle's character set conversion utilities are a=20
must.

Regards,

Mike Thomas

--- "Goulet, Dick" <DGoulet@xxxxxxxx> wrote:
> Actuall? it's just a matte? of makin? thin?s alwa?s
> look ?eadable.
>=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: