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

From: trub3101 <trub3101_at_sky.com>
Date: Tue, 23 Jun 2009 11:38:10 -0700 (PDT)
Message-ID: <d71ab701-01f4-4d31-b9fb-48da04d90d19_at_t21g2000yqi.googlegroups.com>

On 23 June, 17:53, ddf <orat..._at_msn.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

Thanks for reply David,

I am actually logged onto the server and running the sql loader process. The NLS_LANG is set to AMERICAN_AMERICA.UTF8

Cheers,

TB3101 Received on Tue Jun 23 2009 - 13:38:10 CDT