I'm assuming the characters you posted simply aren't rendering correctly in this forum, or does it actually contain all those unknown symbols and question marks?
A few other things you could try, if you haven't already:
- Ensuring the php script sends the header to set the correct charset (Try copy pasting from the DB and printint it out as a string in the script, see if that works. If it does, then we know it's a problem with the actual retrival of info from the DB, as opposed to the characters themselves).
- Set the default character set in your my.cnf file [link]
- Change the collation of your whole table and see if that makes a difference
No, the forum is showing it correctly. That's exactly how it's outputting.
I tried everything that you suggested just there, but with no joy
If you're right about the outputting of the string then it's to do with the DB because the string outputs correctly from the PHP but displays incorrectly from the PDO database retrieval.
This is an absolute nightmare
This post has been edited by mccabec123: 24 July 2012 - 06:05 AM