I upgraded my site from 4.6.5 to 4.7 (and now 4.7.1) and came into the following problem.
Hyphens & quotes now show up as funny characters but if I SSH into the server and request the same node from MySQL, it looks fine!
Here's a page that's not displaying correctly (Presentation Skills – 7 Top Tips):
http://small-business-hub.co.za/node/453
And here's the output of MySQL on the box:
mysql> select title from node where nid = 453;
+------------------------------------+
| title |
+------------------------------------+
| Presentation Skills – 7 Top Tips |
+------------------------------------+
1 row in set (0.00 sec)
And from node_revisions...
mysql> select title from node_revisions where nid = 453;
+------------------------------------+
| title |
+------------------------------------+
| Presentation Skills – 7 Top Tips |
+------------------------------------+
1 row in set (0.00 sec)
mysql>
PLEASE help. It looks horrible and there are way too many articles for me to fix this myself.
PS: If I add new articles with Windows-type quotes and hyphens, it works just fine.
PPS: I also recently upgraded from MySQL 4.0.x to MySQL 4.1.x.
The question is: How do I fix this?
Comments
MySQL table encoding
http://drupal.org/node/22218#utf8_sql this may have something to do with it.
But now what?
Yup, but now what? How do I convert these weird characters back to something humans can read?