Reviewing the contents of a database on SQL Server 2005, I've found completely at random, strange characters often in place of the single quote. I have the single quote escaped as anyone would by replacing it with regular expressions with two single quotes. The last one I've found I'm wondering if it because used an accented character it is "exposÃ©", is this because they used an accented e? That is what I would assume had I not found similar strange character combinations where single quotes should be in many records, but not all, even the same word in the same field.
It is being sent POST data to PHP 5, I've gone through the script and I don't use htmlentities etc.