I'm moving a client's WordPress site from an old host to a shiny new one. I've done a MySQL Dump of the WP database, and imported it into the new host.
Everything has worked smoothly, except, apostrophes are being encoded as question marks.
I've done a little research and the closest I've got is saving the .sql dump in UTF8 (which I've done), then trying to import again - no luck. I've also changed every reference of DEFAULT CHARSET=latin1; in the MySQL dump to DEFAULT CHARSET=utf8;, however, this also makes no difference.
In some odd cases (I can't remember the exact configuration), apostrophes are lost entirely, not replaced with anything, but they just disappear.
They aren't standard straight apostrophes (') but rather right curly quotes I believe (’) - e.g. they're ’, not '. Hope that comes out ok on SO!
Any advice?
Thanks!
Jack
Where do they appear as ?? When you view it in your browser?
Do you send UTF8 as charset in the headers?
header('Content-Type: text/html; charset=utf-8');