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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.