Loading UTF8 fixed length file using SQL Loader 8i
From: Nicolas Mayoraz <nm01_at_dkweb.ch>
Date: 7 Jan 2005 02:02:41 -0800
Message-ID: <1f9a8c6.0501070202.723d512c_at_posting.google.com>
[Quoted] Anurag Varma (avdbi_at_hotmail.com) wrote
Date: 7 Jan 2005 02:02:41 -0800
Message-ID: <1f9a8c6.0501070202.723d512c_at_posting.google.com>
[Quoted] 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 Received on Fri Jan 07 2005 - 11:02:41 CET