can SQL Loader read fixed length data files as chars instead of bytes
I am using sqlloader to load data with polish characters.This is the data:
LeadyManualOddział00Leady Manualneział
---------------
ctl:
LOAD DATA
CHARACTERSET UTF8
TRUNCATE
INTO TABLE CAMP_CONV
WHEN (CMPID != 'TRL')
TRAILING NULLCOLS
(
CMPID POSITION(1:20) CHAR,
DESCRIPTION POSITION(21:120) CHAR)
---------------
The data in DB should be: CMPID LeadyManualOddział00 and DESCRIPTION Leady Manualneział
But the loaded data is CMPID LeadyManualOddział0 and DESC 0Leady Manualneział
Any suggestions
Thanks
Ram
LeadyManualOddział00Leady Manualneział
---------------
ctl:
LOAD DATA
CHARACTERSET UTF8
TRUNCATE
INTO TABLE CAMP_CONV
WHEN (CMPID != 'TRL')
TRAILING NULLCOLS
(
CMPID POSITION(1:20) CHAR,
DESCRIPTION POSITION(21:120) CHAR)
---------------
The data in DB should be: CMPID LeadyManualOddział00 and DESCRIPTION Leady Manualneział
But the loaded data is CMPID LeadyManualOddział0 and DESC 0Leady Manualneział
Any suggestions
Thanks
Ram
0