OraFAQ Forum: Server Utilities » Sqlloader and multibyte charset

Home » RDBMS Server » Server Utilities » Sqlloader and multibyte charset (10.2 , Win Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sqlloader and multibyte charset [message #348042]

Mon, 15 September 2008 08:28

murgawilddog
Messages: 7
Registered: September 2008
Location: Belgrade Serbia

Junior Member

Hello,

I have a following situation.
I have a multibyte datafile which looks something like this :

231Марјан Николић 34
345Велимир Ћоровић 45
465Дунђерски Панта 56

And for the sake of simplicity a table structure like this :

CREATE TABLE LOADER_TEST (
USR_ID NUMBER NOT NULL ,
USR_NAME VARCHAR2(50) ,
control number
);

When trying to load it with sqlloader with this control file :

LOAD DATA
INFILE 'loadertest.txt'
BADFILE 'loadertest.bad'
DISCARDFILE 'loadertest.dsc'
APPEND
INTO TABLE murga.loader_test
TRAILING NULLCOLS

(USR_ID POSITION(1:3) INTEGER EXTERNAL,
USR_NAME POSITION(4:21) CHAR,
CONTROL POSITION(22:23) INTEGER EXTERNAL)

I get the following :

Record 1: Rejected - Error on table MURGA.LOADER_TEST, column CONTROL.
Multibyte character error.
Record 2: Rejected - Error on table MURGA.LOADER_TEST, column CONTROL.
Multibyte character error.
Record 3: Rejected - Error on table MURGA.LOADER_TEST, column CONTROL.
Multibyte character error.

my NLS_LANG is American_America.Al32UTF8

I cannot change the datafile since it is part of automation process.

Please help
Tnx in advance

Report message to a moderator

Re: Sqlloader and multibyte charset [message #348049 is a reply to message #348042]

Mon, 15 September 2008 08:44

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use CHARACTERSET Parameter to tell Oracle with which character set your file is written.

Regards
Michel

Report message to a moderator

Re: Sqlloader and multibyte charset [message #348071 is a reply to message #348049]

Mon, 15 September 2008 09:40

murgawilddog
Messages: 7
Registered: September 2008
Location: Belgrade Serbia

Junior Member

I set the characterset to UTF8, still have the same result...

Report message to a moderator

Re: Sqlloader and multibyte charset [message #348086 is a reply to message #348071]

Mon, 15 September 2008 10:30

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is your file in UTF8?

Regards
Michel

Report message to a moderator

Re: Sqlloader and multibyte charset [message #348088 is a reply to message #348042]

Mon, 15 September 2008 10:38

murgawilddog
Messages: 7
Registered: September 2008
Location: Belgrade Serbia

Junior Member

Yes it is...

Tnx for prompt response.

I'm trying to find a solution using oracle documentation , but with no success.

Attachment: loadertest.txt
(Size: 0.12KB, Downloaded 1703 times)

Report message to a moderator

Re: Sqlloader and multibyte charset [message #348089 is a reply to message #348042]

Mon, 15 September 2008 10:39

murgawilddog
Messages: 7
Registered: September 2008
Location: Belgrade Serbia

Junior Member

Yes it is...

Tnx for prompt response.

I'm trying to find a solution using oracle documentation , but with no success.

Report message to a moderator

Previous Topic:	Sqlldr
Next Topic:	Control File for Listener.log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 16:16:16 CST 2025