Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question

From: lsllcm <lsllcm_at_gmail.com>
Date: Mon, 6 Apr 2009 18:30:32 -0700 (PDT)
Message-ID: <a06b3e4f-36bb-4198-b05b-8925fa8eca6b_at_s22g2000prg.googlegroups.com>

On Apr 6, 8:45 pm, lsllcm <lsl..._at_gmail.com> wrote:
> 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

The string is "sys. Med"

Thanks Received on Mon Apr 06 2009 - 20:30:32 CDT