Re: Converting ISO8859p1 to UTF8.

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 11 Mar 2004 00:57:02 GMT
Message-ID: <yPO3c.20058$KB.2064@twister.nyroc.rr.com>

"|||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.
>
> Regards.
>
>
> --
> Olivier
> http://e-cologis.com
> French free find-a-roommate service.
>

export with NLS_LANG set to we8iso8859p1 ... and import with NLS_LANG set to we8iso8859p1.

What are you setting the NLS_LANG to while exp/imp?

Anurag Received on Wed Mar 10 2004 - 18:57:02 CST