This is still a problem with your character set.
At the very start of your page, before any output, add
header("Content-type: text/html; charset=utf-8");. It has to be before any output in order to have an affect (or have ini/perdir setting for output buffering enabled).
I insert data into the database manually <-- theres your problem
inserting an apostrophe need to be entered with a backslash
mysql_real_escape_string() does this for any characters that it needs to automatically
I have spent today\’s afternoon at Naro-Moru Primary School,
also read this about retrieving safe data from the database
This character �, which is appearing on a webpage everywhere there is supposed to be a single quote, is giving me headaches. The data is being displayed from a database. I've followed advice from previous posts but none is working: changing fonts, putting a header with charset as utf-8. My db collation is utf8-bin. How do I make the single quote appear?
Fix your byte order marker problem yet? Until you do that, the charset won't work when used with a header.
Upload a copy of the file saved as .txt.
Originally Posted by Thuita Maina
you need to enter a bachslash before every single quote in your data
The character you are trying to use is a curved quote and not the straight ' character.
Either replace the ’ with a ' or with ’ (which is the entity code for that fancy quote mark)
your not listening, you cant input a quote into a database without a backslash because you get problems, hence the reason your here