Re: Problems loading data into the database using SQL Loader.
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 24 Jun 2009 19:43:50 +0200
Message-ID: <4a4265d8$0$2859$ba620e4c_at_news.skynet.be>
trub3101 schreef:
> 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
Date: Wed, 24 Jun 2009 19:43:50 +0200
Message-ID: <4a4265d8$0$2859$ba620e4c_at_news.skynet.be>
trub3101 schreef:
> 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
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