Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Character set changes on export
If you don't set the NLS_LANG parameter you will lose all special characters
when you restore the dump. Characters like ë, è. It has happened to in
earlier (7.2) versions of Oracle because export utility did not warn about
exporting in US7ASCII
Ron Denham wrote in message <36731B29.E82F5662_at_mindspring.com>...
>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 Mon Dec 14 1998 - 10:01:10 CST