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

From: Gerard H. Pille <>
Date: Wed, 24 Jun 2009 19:43:50 +0200
Message-ID: <4a4265d8$0$2859$>

trub3101 schreef:
> Hi all,
> Database
> Oracle
> 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

Maybe the data is stored correctly and you're getting the wrong results when retrieving?

And the input file you show, is not in UTF-8, is it? Received on Wed Jun 24 2009 - 12:43:50 CDT

Original text of this message