SQL Loader: how to load strings including a newline char

Hi,

I like to load data which includes newline characters hEC, hA0 (windows platform) in some text fields.
These text fields are used for comments and the user wants to see his formatted text.
The SQL Loader uses the hA0 character to determine the end of each record, although the fields are
delimited by ';' and strings are enclosed in " the loader doesn't read to the end of the record, but only
until the first hA0. Any ideas ?

Many thanks and
best regards

Thorsten Bertram
PLANWARE Beratung & Software GmbH

 Tel: (089) 54 09 36 - 23
 Fax: (089) 54 09 36 - 40
 Adr: Gollierstr. 70, 80339 München

 email: thorsten.bertram_at_planware.com  web: www.planware.com Received on Wed Jul 12 2000 - 00:00:00 CEST