Web Hosting Talk







View Full Version : Black Diamond Question Marks Redux


riddleyw
07-05-2009, 01:57 PM
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?

ThatScriptGuy
07-05-2009, 02:01 PM
More than likely it's an issue with your PAGE charset being incorrect/not matching the data charset.

This page: http://www.webhostingtalk.com/showthread.php?t=621254 offers some helpful information.

cartguy
07-06-2009, 04:27 PM
Maybe use HTML codes for special characters ... I had this problem moving content from a MySQL to Postgresql db.