Carriage-Return in text field

Started by sasan3@gmail.comover 19 years ago2 messagesgeneral
Jump to latest
#1sasan3@gmail.com
sasan3@gmail.com

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.

#2Kevin Field
kev@brantaero.com
In reply to: sasan3@gmail.com (#1)
Re: Carriage-Return in text field

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

Show quoted text

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.