WE8ISO8859P1 convert to AL32UTF8 unicode character set question
From: lsllcm <lsllcm_at_gmail.com>
Date: Mon, 6 Apr 2009 05:45:23 -0700 (PDT)
Message-ID: <f584072f-9db1-48b4-9b0e-35e89690eba5_at_b7g2000pre.googlegroups.com>
Hi Friends,
[Application data individual exceptions]
Date: Mon, 6 Apr 2009 05:45:23 -0700 (PDT)
Message-ID: <f584072f-9db1-48b4-9b0e-35e89690eba5_at_b7g2000pre.googlegroups.com>
Hi Friends,
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;
Is report of cssacn not correct?
Thanks
Jacky
Received on Mon Apr 06 2009 - 07:45:23 CDT