Re: Carriage Returns

My guess is that you are getting an SQL error returned to you. What does that say? Is it talking about a broken SQL statement? Also, an example of the actual insert statement with example data would be helpful. Dan Shirah wrote: > 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 >