Converting WE8ISO8859P1 TO UTF8

From: Ankur Godambe <agodambe_at_ketera.com>
Date: Tue, 6 May 2008 04:45:34 -0700
Message-ID: <F2B0430DD90A1C4383C1F887FBAC45DB0620D21E@kusex2.ketera.com>


Hello All,  

I want to change character set of our existing databases from WE8ISO8859P1 to UTF8 for which I am following steps mentioned on Metalink Note:260192.1.
Point #2 of the note checks invalid code points in current character set and suggests way to clear up "Lossy" data. On running csscan with FROMCHAR=WE8ISO8859P1 and TOCHAR=WE8ISO8859P1 I see lot of tables as "lossy". The way to recover from this situation, as suggested in note, is changing the character set to WE8MSWIN1252 if the following command has all data reported as changeless:

csscan FULL=Y FROMCHAR=WE8MSWIN1252 TOCHAR=WE8MSWIN1252 LOG=1252check CAPTURE=Y ARRAY=1000000 PROCESS=2 Question:
1. Shouldn't the command be FROMCHAR=WE8ISO8859P1 and TOCHAR=WE8MSWIN1252 instead of same FROMCHAR and TOCHAR both = WE8MSWIN1252?   Thanks,

Ankur        

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 06 2008 - 06:45:34 CDT

Original text of this message