Re: Character set changes on export

I don't think you'll lose any information, however. Anybody care to comment on this?

Sybrand Bakker wrote:

> Hi Jan,
>
> Your unix user doesn't have the NLS_LANG environment variable set. In that
> case NLS_LANG will default to AMERICAN_AMERICA.US7ASCII. You need to make
> sure you explicitly set NLS_LANG in your login scripts to
> AMERICAN_AMERICA.WE8ISO8859P1, and the database will be exported
> correctly.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Jan Dolman wrote:
>
> > All our databases are configured to use an 8 bit West European
> > character set. However, when I export a database, the message
> > 'Exporting using US 7 bit character set' appears. I haven't checked
> > yet, but I think I will lose all special characters when exporting. Is
> > this correct? If so, how do I export using the 8-bit character set?
> >
> > We are running Oracle 7.3.3 on Solaris. I export databases using the
> > exp utility from the Unix prompt or a script.
> >
> > Thanks
> > --
> > Jan
> > pantah_at_commonsense.a2000.nl
> > (replace "commonsense" with "speed" to reply)
>
> ------------------------------------------------------------------------
>
> Sybrand Bakker <postbus_at_sybrandb.demon.nl>
>
> Sybrand Bakker
> <postbus_at_sybrandb.demon.nl>
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Bakker
> First Name Sybrand
> Version 2.1
Received on Sat Dec 12 1998 - 19:40:57 CST