Re: Help with carriage return in varchars

From: Tuomas Hosia <tuomas.hosia_at_helsoft.fi>
Date: Thu, 24 May 2001 07:08:38 GMT
Message-ID: <3b0cafcb.163549912@news.helsoft.fi>

"Randall Roberts" <randall_at_filer.org.nospam> kirjoitteli seuraavaa:

>essbee <spare_brain_at_yahoo.com> wrote in message
>news:yjYO6.41024$4f7.3048876_at_bgtnsc06-news.ops.worldnet.att.net...
>> Could someone please provide some advise on how to store a carriage-return
>> (like \n in C++) in a VARCHAR2 field?
>>
>Don't use carraige returns [CHR(13)], use line feeds [CHR(10)]
>
>INSERT INTO the_table (the_column)
> VALUES ('Two'||CHR(10)||'Lines');

This is true if you are
a) not using MS-platform for clients or b) using Oracle-tools for showing data (Forms etc.).

Our company uses Centura (an application development package) for some applications and as a windows-program, it doesn't understand a line feed alone, there has to be a CR-LF -combination.

Tuomas Received on Thu May 24 2001 - 02:08:38 CDT