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

: I'm trying to load an UTF8 file with fixed length record using SQL: Loader for Oracle 8i.

But utf-8 isn't fixed length.

: Unfortunately, SQL Loader does not make the difference between bytes: and characters. i.e. that if two bytes are used to code an accentuated: character (like é) SQL loader will consider that two caracters has: been read meaning that beginning of next field will be shifted.

: I know that there is a LENGTH SEMANTICS CHAR option in Oracle 9i but: I haven't found anything similar in 8i.

: Does anybody know a work around ?

One possibility...

Make the fields in the load file long enough to contain the maximum length
of utf-8 data for that field, and then pad the bytes of each field to be
that length when you create the load file, and then trim off the padding
as the field is inserted into the table.