character set conversion

Hi,

I'm investigating a conversion of charactersets. I have WE8ISO8859P1 on the database 9.2.0.6, HP-UX 11.11 I have clients either with WE8ISO8859P1 or WE8MSWIN1252 Accoording to the docs I have run cssan with current charset in from and to This reports mainly quite a few exceptions. These are the garbage in certain fields
and are probably euro signs that could not be converted. When I do the csscan with old and new charterset it reports the same exceptions.

If I interpret the docs correctly I cannot use the alter database characterset command
due to exceptions and different clientsettings. But why not??: 1) I already have garbage in the database so this must / might be cleaned by the users
2) Business wants to store and use the euro sign for future data 3) I could change all clients with their characterset to the new one

Tnx in advance,

Jeroen

--
http://www.freelists.org/webpage/oracle-l