Re: Character set changes on export

From: JanJan <pantah_at_commonsense.a2000.nl>
Date: Mon, 14 Dec 1998 17:03:38 GMT
Message-ID: <367543ff.989714@news.a2000.nl>

On Mon, 14 Dec 1998 17:01:10 +0100, Patrick Bogers wrote:

>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

Right, we've tried it today. Most special charactes will be converted to their 'normal' equivalent (ë -> e), but some characters are converted to question marks (ï). Setting the NLS_LANG variable solves everything.

Thanks for helping
--
Jan
pantah_at_commonsense.a2000.nl
(replace "commonsense" with "speed" to reply) Received on Mon Dec 14 1998 - 11:03:38 CST