Re: Need Help: Question on Export/Import
Date: Thu, 5 Feb 2004 22:34:41 +0800
Message-ID: <bvtlg5$1e2i$1_at_news.hgc.com.hk>
Thanks. It works now.
Originally I set the NLS_LANG to AMERICAN_AMERICA.ZHT16BIG5 in
HKLM\Software\Oracle and it doesn't work.
Just for information. The export/import can also be done correctly by setting the NLS_LANG in windows environment variable or in dos command.
Thanks again.
M
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:402145f1$0$18966$636a55ce_at_news.free.fr...
>
> "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.
> If your export log says that export was done in we8iso8859p1 character set
that means
> that NLS_LANG of user doing the export was with this character set and
this is why
> you lost some characters: when export is done, character set of db is
converted to the one
> of the environment of the export.
> Check your environment variables in the registry
HKLM/Software/Oracle/HomeX.
>
> Regards
> Michel Cadot
>
>
Received on Thu Feb 05 2004 - 15:34:41 CET