Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ASCII CR-LF representation within column

Re: ASCII CR-LF representation within column

From: Prasad Chavali <pchavali_at_assettech.com>
Date: Tue, 9 Mar 1999 18:08:35 -0700
Message-ID: <7c4gmh$665$1@nnrp02.primenet.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US