sqlldr ignores carriage return and linefeed
255656Jul 30 2003 — edited Aug 4 2003Hello,
I have a string which is written over more than one line. When I put this string into the database with sqlldr than the carriage returns and linefeeds are removed and in the database there is only one line left.
i.e.
This car
has a red color
and is parked under the tree.
After I load this into the database it will be
This car has a red color and is parked under the tree.
If I convert my file from unix to dos (I'm running sqlldr under unix) then a ^M is put after each line and then I'll get the right lines into the database. But is there a way so that unix won't ignore my carriage return and line feed?