Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlldr, multibyte character, one character off

Brian TkatchJun 16 2014 — edited Jun 18 2014

Control file:

LOAD DATA


CHARACTERSET UTF8 LENGTH CHAR


TRUNCATE


INTO TABLE Test


(


A POSITION(001:003),


B POSITION(004:008),


C POSITION(020:054),


D POSITION(055:089),


F POSITION(090:129),


G POSITION(130:169),


H POSITION(170:209),


I POSITION(210:249),


J POSITION(250:255),


K POSITION(256:259),


L POSITION(260:299),


M POSITION(300:339),


N POSITION(340:356),


O POSITION(357:361),


P POSITION(362:366),


Q POSITION(367:374),


R POSITION(375:376),


S POSITION(378:379),


T POSITION(380:390)


)

Using sqldr from Linux causes each field after the field with the "multibyte character" to be off by one character. Record with no such characters do not exhibit this issue.

Example data that causes issue (field C): Fran«ois

How do i import this data properly?
This post has been answered by Richard Harrison . on Jun 17 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 16 2014
Added on Jun 16 2014
#database-key-features, #export-import-sql-loader-external-tables
15 comments
7,559 views