Dan Shirah wrote:
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:
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
João Cândido de Souza Neto wrote:
Are you using nl2br to convert before recording or after?
This is probably an Informix problem or a problem with your interface to
Informix. (I say that because I store textarea data with embedded
newlines all the time in MySQL using the PHP mysql_ functions.)
What interface are you using? ODBC?
What errors do you get from Informix when it bombs?
I'm guessing an embedded CR or LF character is breaking something as
it's being passed to Informix. As João implies, if you really are
changing these to break tags, you shouldn't have a problem. So you might
try outputting the results of your conversion to your PHP error log
before you pass it to Informix.
You may find more help on an Informix list.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php