Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!fr.ip.ndsoftware.net!proxad.net!feeder2-1.proxad.net!news4-1.free.fr!not-for-mail From: "Michel Cadot" Newsgroups: comp.databases.oracle.tools References: <401fe3d5$0$32650$626a54ce@news.free.fr> <40212711$0$18986$636a55ce@news.free.fr> Subject: Re: Need Help: Question on Export/Import Date: Wed, 4 Feb 2004 20:22:27 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Lines: 31 Message-ID: <402145f1$0$18966$636a55ce@news.free.fr> Organization: Guest of ProXad - France NNTP-Posting-Date: 04 Feb 2004 20:20:17 MET NNTP-Posting-Host: 82.67.171.166 X-Trace: 1075922417 news4-1.free.fr 18966 82.67.171.166:1650 X-Complaints-To: abuse@proxad.net Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:84613 "M" a écrit dans le message de news:bvrajb$8j0$1@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