Re: Character set changes on export

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)

Received on Sat Dec 12 1998 - 00:35:16 CST