Re: Converting ISO8859p1 to UTF8.

"|||Cypher|||" <ocotassonATnetcourrierDOTcom> wrote in message news:<404ef148$0$305$626a14ce_at_news.free.fr>...
> Hi Oracle Gurus & fellows.
>
> I have to export a Oracle DB (schema I should say) which character set is
> "we8iso8859p1" into an existing instance encoded in UTF-8.
>
> This generate data inconsistency and, therefore data loss.
> I did not find a way out so far. Neither did DBAs in my company .
>
> Did some of you come across such a problem ?
> Is there a way to solve it ? If so, please drop me a hint.

If the data is valid ISO-8859-1 encoded data, it should be no problem to import it into a UTF-8 database-- UTF-8 can encode every character that ISO-8859-1 can plus a lot more characters. If there are problems, my first concern would be that the data in the ISO-8859-1 database is corrupt and is not actually encoded in the ISO-8859-1 character set. Are you sure that the data in the database is actually ISO-8859-1 encoded data? Are you storing anything other than English or Western European data?

If data corruption isn't the problem, how are you moving the data between the databases?

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC Received on Wed Mar 10 2004 - 17:08:05 CST