Allow space in data

Hey there,

i suppose i have a very simple common but a problem :p in sqlldr.

I want to allow blank space in one of my columns.

say if i want to load the following
'amol '
' amol '
' amol '
' amol '

it gets loaded but i want toi retain the trailing blank characters. what i find in table is the trailing space is truncated and i get data length as
4
5
6
7

e.g 7 includes three prefixed blank characters and the 4 alphabets.

i want to see a regular length of 10 in each row.

any pointers?? any option in the control file of sqlldr??

Thanks,
Amol Cnow what on earth is a 'blank space' ? poor term, ain't it?

hey just dropped in to convey that the length of the data is 10.

'amol '

4 characters + 6 "blank spaces"|||Slightly modify the control file ... add the column length where needed.

Let's say, for example, that your control file looks like this:LOAD DATA
INFILE some_file.txt
INTO TABLE your_table
(column_name POSITION(001:010) CHAR)When loading, you'll lose trailing blanks. To prevent this to happen, the last row in example control file should look like this:(column_name POSITION(001:010) CHAR(10))
P.S. I guess it is about Oracle SQL*Loader utility ... if so, I'd suggest you to post questions regarding Oracle in the Oracle forum.|||User the PRESERVE BLANKS option:
LOAD DATA
INFILE some_file.txt
INTO TABLE your_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
PRESERVE BLANKS
(COL1, COL2, ...etc...
:D