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

From: ddf <oratune_at_msn.com>
Date: Tue, 23 Jun 2009 11:53:46 -0700 (PDT)
Message-ID: <ade6e470-95b3-4215-bc65-20570296aef0_at_j19g2000vbp.googlegroups.com>



On Jun 23, 1:38 pm, trub3101 <trub3..._at_sky.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

We'll need to see your control file and data file.

David Fitzjarrell Received on Tue Jun 23 2009 - 13:53:46 CDT

Original text of this message