I have a MySQL table that contains UTF-8 Characters.
Unfortunately, when I insert contents from my table into my web pages, non ASCII characters are being shown as boxes.
All my pages are properly encoded using the UTF-8 Chartype. If I paste these characters directly into my page, the characters show fine.
The MySQL table has a default Collation of utf8_unicode_ci, and the text cells also have the same collation.
In PhpMyAdmin, when viewing the tables, the characters show properly.
Right now, the only guess I have is that maybe my weak point is when I use PHP to grab the contents form my table and insert them into the page.
I use the following code:
$result=mysql_query("SELECT * FROM table_name WHERE x='$x'");