Skip to Main Content
Forums

Oracle Database Discussions

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 error

SQhellDec 11 2008 — edited Dec 11 2008
Hi,

I am loading a file which have unusual characters e.g.KAROSSERIE-CENTER-OBERROá,
My sqllder control file needs to be position based e.g as per below, but the character is at the end of the field. looks like the character is taking up two spaces and the position cannot handle it, i need to keep is as postional, anyway around this.

thanks

Record 2: Rejected - Error on table XXXX, column OWNER_NAME.
Multibyte character error.



LOAD DATA
CHARACTERSET UTF8
INFILE 'C:\XXXXX.txt'
BADFILE 'BUSINESSLOGSDATAEXEC.BAD'
DISCARDFILE 'BUSINESSLOGSDATAEXEC.DSC'
APPEND INTO TABLE XXXXXX

(
OWNER_NAME POSITION (98:107),
)

Comments

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

Post Details

Locked on Jan 8 2009
Added on Dec 11 2008
#error, #general-database-discussions
1 comment
4,569 views