Re: Problems loading data into the database using SQL Loader.

From: ddf <oratune_at_msn.com>
Date: Tue, 23 Jun 2009 09:53:25 -0700 (PDT)
Message-ID: <c1f1c349-6fae-47f5-978d-6119d4069f49_at_l32g2000vba.googlegroups.com>

On Jun 23, 11:42 am, trub3101 <trub3..._at_sky.com> wrote:
> Hi all,
>
> Database
> Oracle 9.2.0.8
> NLS_LANG=AMERICAN_AMERICA.UTF8
> NLS_CHARACTERSET UTF8
> NLS_NCHAR_CHARACTERSET AL16UTF16
>
> Server
> Red Hat Linux 2.6.9-67.ELsmp
> LANG=en_US.UTF-8
>
> I cannot figure this one out. When I try to populate a table using SQl
> Loader I am getting corrupt characters in the table e.g. Alien³
> appears in the table as Alien¿
>
> I have even set the CHARACTERSET to UTF8 in the control file for good
> measure!
>
> Can anyone throw some light on this one?
>
> Thanks in advance for your replies.
>
> TB3101

I'll take a guess that you're doing this from a client machine. What is the NLS_LANG on the machine where you're running the loader?

David Fitzjarrell Received on Tue Jun 23 2009 - 11:53:25 CDT