Re: Character set blues...

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 25 Mar 2005 17:55:30 +0100
Message-ID: <d21fke$oh1$1@news1.zwoll1.ov.home.nl>

Let's start over again...

• your HTTP Post, stored in a CLOB is correct when posted through the ISO8859P1 DAD.
• your HTTP Post, stored in a CLOB *seems* incorrect when posted through the UTF DAD.

Do you have any clue as to what actually is stored, when you use the UTF DAD? Try to find out, e.g. by using the dump function. My guess is, you will find just 1 byte of the two actually used.

Here's an example of what an UTF (AL16UTF16) nvarchar column looks like:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

hr_at_O920.CSDB01.CS.NL> create table blues (col1 varchar2(40),

   col2 nvarchar2(40));
Table created.

hr_at_O920.CSDB01.CS.NL> insert into blues (col1, col2)   values ('ori๋nterend','ori๋nterend');
1 row created.

hr_at_O920.CSDB01.CS.NL> select * from blues;

COL1                                     COL2


---------------------------------------- 

---------------------------------------

-

ori๋nterend                              ori๋nterend

hr_at_O920.CSDB01.CS.NL> select dump(col2) from blues;

DUMP(COL2)

---

Typ=1 Len=22:

0,111,0,114,0,105,32,48,0,110,0,116,0,101,0,114,0,101,0,110,0,100


------------------^^^^^

hr_at_O920.CSDB01.CS.NL> select dump(col1) from blues;

DUMP(COL1)

---

---

Typ=1 Len=11: 111,114,105,137,110,116,101,114,101,110,100
--------------------------^^^

hr_at_O920.CSDB01.CS.NL> select ascii('๋') from dual;

ASCII('๋')

---

        137
The "๋" is 137 when stored in WE8MSWIN1252, and 2 bytes (of course: AL16UTF16!), 32, 38, in UTF.

I am curious to know what a dump() would show

--

Regards,
Frank van Bortel Received on Fri Mar 25 2005 - 10:55:30 CST