UTF-8 characters from MySql database not displaying on web page

Recipe title on this page has a ’ character that is not displaying properly:
http://www.berksfoods.com/recipe-hot-dog/?id=36

It is coming from a database. When I am looking at the title in phpMyAdmin, I see:
Berks Fiesta Hot Dog Hors D’oeuvres

But on the web page, I see:
Berks Fiesta Hot Dog Hors D�oeuvres

My doctype is:
<!DOCTYPE html>

I also have this meta tag:
<meta charset="utf-8">

Shouldn't that be enough to make the UTF-8 character display properly? I'm not sure what I'm doing wrong.

Thank you!
Brad BansnerWeb DeveloperAsked:
Who is Participating?
 
Dave BaldwinFixer of ProblemsCommented:
Trouble is that it's not a UTF-8 character but a Latin1 character.  You would have to make it a different 'code point' for it to be that same character in UTF-8.
0
 
Dave BaldwinFixer of ProblemsCommented:
Or you could use "&#8242; or &prime;" character entities.  http://www.alanwood.net/demos/ent4_frame.html
0
 
Brad BansnerWeb DeveloperAuthor Commented:
Thanks for the advice. In the meantime, I converted them from fancy to plain quotes, to fix the problem.

It must be true that you can use those characters without encoding them with & HTML codes. I know I have done it in the past. And MySql displays it properly on my screen.
0
 
Dave BaldwinFixer of ProblemsCommented:
Sorry, it just does not work that way.  Character sets and Unicode / UTF-8 can be very confusing and irritating.  Almost all character sets have the ASCII character set, the first 127 codes, in common.  After that, they vary greatly.  Latin1 is a single byte code set which restricts it to 256 characters.  Unicode / UTF-8 is a multi-byte character set with over 1 million possible characters.

The default character set for PHP and phpMyAdmin has been Latin1.  The new versions may be switching to UTF-8.  The default character set in Windows is Windows-1252 which is essentially Latin1.

Here http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/A_11880-Unicode-PHP-and-Character-Collisions.html is an article by Ray Paseur on the subject.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.