| LOADING PROBLEM IN SQL LOADER (MULTIBYTE CHARACTER ERROR) [message #72144] |
Mon, 24 March 2003 03:58 |
Willie Castro
Messages: 1
Registered: March 2003
|
Junior Member |
|
|
I need your expert advise on my problem.
We are converting data using SQL Loader and somehow we cannot load to a field
which is defined as char(4)in Oracle Table with the data defined as s9(9)
binary in COBOL. We suspect that the datafile character set differ with
database character set. We have check the nls_database_parameters and the value
of nls_characterset = ZHT16BIG5 which seems to be correct.
Characterset = ZHT16BIG5
NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
value = 999999998 hex=3B9AC9FE
ERROR MESSAGE :
Record 1: Rejected - Error on table BINTEST3, column COL2.
Multibyte character error.
Here is my sqlldr script:
LOAD DATA
INFILE 'BINTEST.dat' "FIX 24"
APPEND
INTO TABLE BINTEST3
FIELDS TERMINATED BY '|'
(COL1 POSITION(1) CHAR(4),
COLX POSITION(6) CHAR(9),
COL22 POSITION(16) CHAR(4),
COL2 POSITION(21) CHAR(4))
The COL2 is the one that has a multi-byte character.
But this problem works with CHARACTERSET US7ASCII (7-bit) and loaded this
DATA successfully. The problem is we really need to LOAD this DATA into a
ZHT16BIG5 CHARACTERSET and not in US7ASCII.
OS : HPUX 11.00
Oracle version : 8.1.7.0.0 (32 bit)
Thank you in advance for the HELP.
Best Regards,
Willie Castro (Manila, Philippines)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
