Oracle Application Express (MOSC)

MOSC Banner

can SQL Loader read fixed length data files as chars instead of bytes

edited Jun 10, 2012 10:10PM in Oracle Application Express (MOSC) 1 commentAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center