I've run into this issue a bit...
Do you mean, it's in the DB okay, but when it comes back to the client it breaks your transport mechanism (say, if you use JSON)? So far I've just been using a replace...if you find another way I'd love to hear it. (Because I also have to escape quotes and backslashes, being careful about order...)
Kev
>
>
> How do I insert text into a TEXT field that has a carriage-return in
> it?
>
> I can obviously replace all CR with \n but isn't there an easier way to
> do it?
>
> Thanks.
>