Re: Loading UTF8 fixed length file using SQL Loader 8i

"Nicolas Mayoraz" <nm01_at_dkweb.ch> wrote in message news:1f9a8c6.0501070202.723d512c_at_posting.google.com...
> Anurag Varma (avdbi_at_hotmail.com) wrote
>
> >What happens if you define the ctl file as?:
> >
> >LOAD DATA
> >CHARACTERSET UTF8
> > INFILE 'XXX.txt'
> >REPLACE
> >
> > INTO TABLE tmp.MY_TABLE
> > (
> > LASTN char(20), -- Last name
> > FIRSN char(20), -- First name
> > STATU char(1), -- Status
> > BIRDT char(8) -- Date of birth
> >)
> >
> >?
> >
> >Anurag
>
> With SQL Loader 8i it's not working properly. But I managed to install
> SQL Loader 9i and it's working well with the LENGTH SEMANTICS CHAR
> option and using the syntax you proposed above.
>
> Best regards,
>
> Nik

hmm .. well I see different results
[Quoted] .. I did a test on a 8.1.7.4 database and found that it works with the syntax I posted above. I tested it with greek and french data.
Although POSITION(x:y) refers to bytes in 8i, the char (afaik) refers to characters.

Anurag Received on Sat Jan 08 2005 - 00:02:16 CET