Knowledgebase

Black Diamond Question Marks Redux

Posted by 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 particular 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?

Posted by 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.

Posted by 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.

Add to Favourites

Print this Article