Question marks inside diamonds

[riddleyw]

My mysql database has a field that shows perfectly when viewed in myphpadmin. However, when I display it via my php web page certain characters (mostly apostrophes) display as black diamonds with question marks. The database is in utf8_general_ci.

The fact that it displays properly in PHPmyadmin suggests it is something in my web page or that they have a good trick for avoiding this problem.

Does anyone know what I can do?

[whoisgregg]

Welcome to WebmasterWorld, riddleyw!

Check that your HTML is setting the content-type to UTF-8:

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

[bkeep]

Also when displaying the data to the page use htmlentities() if you are using PHP