Hi,
I’m trying to develop a website which will accept user written input in a form and will store it in a MySQL database, and will have no problems if the user written text has a ’ in it. For this I was referred to this site:
http://www.developer.com/db/print.php/10920_2184681_6
and it looks pretty easy, what I have to do.
The problem is, when I use $dbh->quote, from my error logs I can see that it is substituting a ’ with \’, ie. “O’Reilly” becomes “O\'Reilly”, instead of “O’Reilly”, and I can’t tell why.
Can someone help?
Thanks.