Re: Problems loading data into the database using SQL Loader.
From: trub3101 <trub3101_at_sky.com>
Date: Wed, 24 Jun 2009 11:55:17 -0700 (PDT)
Message-ID: <163aa7bf-b5ec-4367-99a3-ec3186c1561e_at_r3g2000vbp.googlegroups.com>
On 24 June, 18:43, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> 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?- Hide quoted text -
>
> - Show quoted text -
Date: Wed, 24 Jun 2009 11:55:17 -0700 (PDT)
Message-ID: <163aa7bf-b5ec-4367-99a3-ec3186c1561e_at_r3g2000vbp.googlegroups.com>
On 24 June, 18:43, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> 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?- Hide quoted text -
>
> - Show quoted text -
Thanks for your reply Gerard,
After consulting one of the devs earlier it would appear that file is in 'ISO-8859-1' character encoding format. I guess I will now need to convert this to UTF-8 character encoding somehow.
The Linux iconv command does seem to make any difference the data is still appearing corrupted in the database.
Anyone?
Cheers,
TB3101
Received on Wed Jun 24 2009 - 13:55:17 CDT