Msg#: 12214 posted 12:06 pm on Mar 22, 2006 (gmt 0)
Run phpinfo() in a script on your server and check to make sure your quote settings are as they should be. Also if you've recently upgraded make sure that PHP is still opening the proper .ini file - which can be checked with the output of phpinfo().
Msg#: 12214 posted 4:30 pm on Mar 22, 2006 (gmt 0)
How are you preparing the text prior to using the text in an INSERT statement? I ask because this sounds to me as though there may be an extra addslashes() or mysql_real_escape_string() in there somewhere. If you could build your full query into a $query variable and then:
and then paste that query here it would be really helpful. Also if you're using mysql check to see if you're using the quote() function in either the INSERT or SELECT.