Re: loading <CR/LF> into a varchar field

I ended up writing my own Pro*C-routine to load cr/lf into the database.

Fuzzy wrote:
>
> Hi people,
>
> I've got an app that has the ability to show multi-line text fields.
>
> The tables can be loaded using SQL*Loader, but I've got a problem when
> loading the above-mentioned text fields. I use 0x0d and 0x0a (the
> codes for <cr> and <lf>) in the actual text of the field, hoping it
> will be passed through, and stored in the database. SQL*Loader
> decides to read these, rather than pass them through as the contents
> of the field, spitting the line out as bad because it is broken over
> two lines.
>
> Has anyone got around this? (Sorry if the description is a bit
> confusing).
>
> Ciao
> Fuzzy
> :-)
 

-- 
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Lars Jørgen Tvedt, Dokumentasjonsprosjektet, Universitetet i Oslo
Postboks 1123 Blindern, N-0317 OSLO  
Telefon (+47) 22 85 49 84,    Fax (+47) 22 85 49 83