Carriage Returns
| From: | Dan Shirah | Date: | Fri, 06 Nov 2009 16:24:00 +0000 |
| Subject: | Carriage Returns | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-299682@lists.php.net to get a copy of this message | ||
Hello all,
Basically I have a form with a <textarea>. The user can enter up to 5,000
characters in this text area.
If the user just types text like: This is a test.
And saves it, there's no problem.
However if the user types:
This
Is
A
Test
And saves it, the insert bombs.
I've tried using nl2br($text) and str_replace("\r","#CR",$text) to convert
the carriage returns, but it still crashes.
I'm using an informix database and the column is: my_text CHAR(5000)
Any ideas why it crashes any time there is a carriage return in the text
area?
Thanks,
Dan