Re: Help with carriage return in varchars

From: wayne <no_at_email.please.com>
Date: 24 May 2001 00:27:41 GMT
Message-ID: <9ehkht$8ob@dispatch.concentric.net>

> Could someone please provide some advise on how to store a carriage-return
> (like \n in C++) in a VARCHAR2 field?

I have loked into this in the past... My solution was to create the DB with the Windows character set (ISO2259P1, or something like that... Actually, please go look it up in the docs, I am positive this is wrong!).

With the windows character set I could store from character 0 to 255, I was surprised I could store character 0... Anyway, since a CRLF is chaar(10) + char(13) you should have no problem if you use the windows character set.

In the other character sets you may have your characters translated, so if you try to store a char(10) it may get translated to something else (like "?"). Received on Wed May 23 2001 - 19:27:41 CDT