Re: ASCII CR-LF representation within column

Chr(13), Chr(10) combination always works. I use chr(13)||chr(10) usually.

HTH Prasad Chavali
pchavali_at_assettech.com

Hank Riehl wrote in message <7c33f1$12c_at_news-central.tiac.net>...
>We are looking to port some data from Sybase to Oracle. Within some long
>VARCHAR columns, we have user-entered embedded CR-LFs (Carriage-Return,
>Line-Feeds) for data-formatting purposes.
>
>When exporting to ASCII, Sybase represents the CR-LF as
> \x0d\x0a
>which Oracle simply picks up as ascii literals.
>
>I presume Oracle has some sort of ESC-code character sequence for its
>representation of CR-LF. Can anyone tell me what it is so we can do a
>global search-and-replace between the Sybase ascii export and the Oracle
>import?
>
>Many Thanks
>
>
Received on Tue Mar 09 1999 - 19:08:35 CST