Re: Need Help: Question on Export/Import

"M" <someone_at_microsoft.com> a écrit dans le message de news:bvrajb$8j0$1_at_news.hgc.com.hk...
> I have checked that the NLS_LANG of both the original and new DB was
> AMERICAN_AMERICA.ZHT16BIG5. Since they are the same, I'm expecting there
> should be no conversion done during export/import... However, I got
> "Export done in WE8ISO8859P1 character set ..."
>
> Its strange to me cos' I haven't set any WE8ISO8859P1 character set when
> I create the DB !
>
> BTW, the original DB was installed in WinXP and don't have any environment
> variable to set. I found from some forum saying that there's a
> ORA_NLS_CHARACTERSET_CONVERSION parameter to set in UNIX
> environment. Is it work in XP and how to set it?
>
> Thanks again.
> M
>

I was talking about NLS_LANG environment variable of the client doing export/import not about the character set of the DB.
[Quoted] If your export log says that export was done in we8iso8859p1 character set that means [Quoted] that NLS_LANG of user doing the export was with this character set and this is why [Quoted] you lost some characters: when export is done, character set of db is converted to the one of the environment of the export.
[Quoted] Check your environment variables in the registry HKLM/Software/Oracle/HomeX.

Regards
Michel Cadot Received on Wed Feb 04 2004 - 20:22:27 CET