Home » RDBMS Server » Server Utilities » Sqlloader and multibyte charset (10.2 , Win Xp)
Sqlloader and multibyte charset [message #348042] Mon, 15 September 2008 08:28 Go to next message
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


Re: Sqlloader and multibyte charset [message #348049 is a reply to message #348042] Mon, 15 September 2008 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use CHARACTERSET Parameter to tell Oracle with which character set your file is written.

Regards
Michel
Re: Sqlloader and multibyte charset [message #348071 is a reply to message #348049] Mon, 15 September 2008 09:40 Go to previous messageGo to next message
murgawilddog
Messages: 7
Registered: September 2008
Location: Belgrade Serbia
Junior Member

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

Re: Sqlloader and multibyte charset [message #348086 is a reply to message #348071] Mon, 15 September 2008 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is your file in UTF8?

Regards
Michel
Re: Sqlloader and multibyte charset [message #348088 is a reply to message #348042] Mon, 15 September 2008 10:38 Go to previous messageGo to next message
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.
Re: Sqlloader and multibyte charset [message #348089 is a reply to message #348042] Mon, 15 September 2008 10:39 Go to previous message
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.
Previous Topic: Sqlldr
Next Topic: Control File for Listener.log
Goto Forum:
  


Current Time: Mon Dec 05 21:13:14 CST 2016

Total time taken to generate the page: 0.06822 seconds