Re: Help with carriage return in varchars
From: Randall Roberts <randall_at_filer.org.nospam>
Date: Sat, 21 Jul 2001 21:43:01 GMT
Message-ID: <3b0c82b9_2_at_news.pcmagic.net>
Date: Sat, 21 Jul 2001 21:43:01 GMT
Message-ID: <3b0c82b9_2_at_news.pcmagic.net>
Don't use carraige returns [CHR(13)], use line feeds [CHR(10)]
INSERT INTO the_table (the_column)
VALUES ('Two'||CHR(10)||'Lines');
Best!
Randall
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?
>
> Thanks!
>
> essbee
>
>
Received on Sat Jul 21 2001 - 23:43:01 CEST