Converting WE8ISO8859P1 TO UTF8
- From: "Ankur Godambe" <agodambe@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 May 2008 04:45:34 -0700
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
Other related posts:
