Skip to Main Content

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!

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

Mike Kutz

I wish there was a date for "Last updated" on the one site.

It looks like this is (now) a Known Issue (3rd bullet point)

https://oracle.github.io/oracle-db-mle/release_notes/

That "Last updated" would have told me if you (re)discovered this bug or not.  (were you the one that caused them to add that bullet point or did the MLE team already know about it?)

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

Post Details

Locked on Jan 8 2009
Added on Dec 11 2008
1 comment
4,575 views