Re: Export Character Set

From: Jan H Malmberg <jhma_at_gbg.ifsab.se>
Date: 1998/04/28
Message-ID: <6i4tmh$3a8$1@vega.lejonet.se>#1/1

When you export in unix you have to set NLS_LANG to correct values. If not default will be used - NLS_LANG=AMERICAN_AMERICA.US7ASCII and you will lose information. All characters in WE8ISO8859P1 that don’t exist in US7ASCII will be lost - actually they will be translated to ? (a question mark)
in the exportfile.

You will notice this if you have to restore some tables from the exportfile.

JhMa

Logo Palanisamy wrote in message <3545558E.3604_at_SabariSoft.com>...
>Our database (version 7.3.3 on SunOS) was created in "WE8ISO8859P1"
>character set.
>
>When we export from UNIX, the export log says "Export done in US7ASCII
>character set". But when we export from Enterprise Manager, the export
>log says "Export done in WE8ISO8859P1 character set".
>
>Why is this difference? Is this normal?
>
>Would doubly appreciate if you could reply to LogoP_at_SabariSoft.com
>
>Thanks in advance,
>Logo Palanisamy,
>www.SabariSoft.com
Received on Tue Apr 28 1998 - 00:00:00 CDT