How to load a string with blanks into a varchar2 not null column using SQL*Loader

Hi all,

I have a table with a "varchar2(200) not null" column. Trying to load data with SQL*Loader where a row has the value of " " (a single blank character) produces the row in the database that contains a string with a single character '\0'. Tried to use PRESERVE BLANKS with no effect. Here's the control file:

LOAD DATA
INFILE 'data.dat'
PRESERVE BLANKS
INTO TABLE test_table
TRAILING NULLCOLS
( test_id, test_text)

Greetings,
Branko Milosavljevic Received on Sun Sep 21 2003 - 13:15:43 CDT