Text corruption when storing to MySql

From: Date: Wed, 20 Oct 2004 19:49:51 +0000
Subject: Text corruption when storing to MySql
Groups: php.db 
Request: Send a blank email to php-db+get-36938@lists.php.net to get a copy of this message
I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type "text"). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am assuming wierd characters are being introduced in this manner (I definitively know this is a problem with rounded quotes) and although I am using the basic "addslashes" function, it's not enough. Has anyone seen this before and is there a fix? Thanx Gaby

« previous php.db (#36938) next »