Re: Problem with Export and UTF8 Database

Hi,

Thanks for the info.

I'm bit of a newbie to Oracle, but looking at an earlier post in this NG, I set the NLS_LANG to UTF8 in the registry on my NT Client. NLS_LANG is in two places:

hklm\software\oracle\

and

hklm\software\oracle\all_homes\id0

Both these values were previously set to NA.

My question - is this the right place to make the changes as the export is still using US7ASCII.

thanks in advance,

JP

"Andreas Necker" <Andreas.Necker_at_isb-ag.de> wrote in message news:3B5D62C5.A9575E97_at_isb-ag.de...
> hi,
>
> jp wrote:
> >
> > Hi,
> >
> > I have prepared a database on our development server using UTF8
 character
> > set. I now want to move tables from the development server to our live
> > server however when I run the export utility on our development server
 it
> > says "Export done in US7ASCII character set and US7ASCII NCHAR character
 set
> > server uses UTF8 character set (possible charset conversion)"
> >
> > My question is - how do I get the export to use UTF8.
> >
> > thanks in advance,
> >
> > JP
>
> have you set NLS_LANG ?
> if NLS_LANG is not set export will use US7ASCII (default).
>
> --
> Andreas Necker
>
> ISB AG Tel: +49 (0)721/82800-0
> Karlstrasse 52-54 Fax: +49 (0)721/82800-82
> 76133 Karlsruhe mailto:Andreas.Necker_at_isb-ag.de
> Germany http://www.isb-ag.de
Received on Wed Jul 25 2001 - 10:19:01 CEST