ASCII CR-LF representation within column

From: Hank Riehl <hankr_at_skillview.com>
Date: Tue, 9 Mar 1999 07:17:00 -0500
Message-ID: <7c33f1$12c@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 - 06:17:00 CST