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

canen’s picture

http://drupal.org/node/22218#utf8_sql this may have something to do with it.

norio’s picture

Yup, but now what? How do I convert these weird characters back to something humans can read?