Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question

From: lsllcm <lsllcm_at_gmail.com>
Date: Mon, 6 Apr 2009 20:35:54 -0700 (PDT)
Message-ID: <f7003059-fdee-47cd-9dad-0a9ff75cd2bf_at_j18g2000prm.googlegroups.com>

I have one question about CSSCAN when I do conversion from WE8ISO8859P1 to AL32UTF8 unicode character set.

create table aaa (c1 varchar2(10));
insert into aaa values ('sys.…Med');

After csscan the data, get the application exception data as below

---

[Application data individual exceptions]

User  : JACKY
Table : AAA
Column: C1
Type  : VARCHAR2(10)
Number of Exceptions         : 1
Max Post Conversion Data Size: 9
ROWID              Exception Type      Size Cell Data(first 30 bytes)


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

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

AAAYtgAAEAAAEKPAAA lossy conversion         sys.…Med


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

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

But after use convert method and check it, the data can be converted successfully after use below sql

select case when convert(convert(C1, 'AL32UTF8', 'WE8ISO8859P1') ,'WE8ISO8859P1', 'AL32UTF8') = C1 then 0 else
-999999+111111 END from aaa;

Below is dump of data

1. dump in AL32UTF8 character set select dump(convert(c1,'AL32UTF8')) from aaa DUMP(CONVERT(C1,'AL32UTF8'))

   ---

   Typ=1 Len=9: 115,121,115,46,194,133,77,101,100
2. dump in WE8ISO8859P1 character set select dump(c1) from aaa DUMP(C1)

   ---

   Typ=1 Len=8: 115,121,115,46,133,77,101,100 Is report of cssacn not correct?

Thanks Received on Mon Apr 06 2009 - 22:35:54 CDT