Re: Import character set issue:

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Feb 2005 07:43:02 -0800
Message-ID: <1107790982.918741.232050@o13g2000cwo.googlegroups.com>

Sybrand Bakker wrote:
> On 7 Feb 2005 06:22:16 -0800, fmarchioni_at_libero.it (Francesco M.)
> wrote:
>
> >Should I set NLS_LANG with a code that identifies US7ASCII ??
> >where am I wrong ?
>
> The syntax for NLS_LANG=<Territory>_<Country>.<charset>
> so
> American_America.US7ASCII
>
> not US7ASCII alone.

To add to above,
If your client NLS_LANG is already set to same as your target database then you don't need to change the NLS_LANG. You are OK as long as your client NLS_LANG is either same as your export file OR same as your target database.

Regards
/Rauf Received on Mon Feb 07 2005 - 09:43:02 CST