I've just upgraded to 3.0.1 and switched to a new server. Full story below, but the result has left with incorrect encoding on the transfered entries. Any easy way to fix this?
Specifically: we use
¥ to put in the Japanese Yen mark. After the upgrade, although
¥ appears correctly in the SQL DB, once in WordPress, the characters aren't correctly resolved. When viewing in both 'Visual' and 'HTML' editing view, the characters are garbled. If edited in HTML view to ¥ it works fine, but we have 1,000s of these entries, so this isn't an option.
Also, quote marks and some other characters are also garbled.
Any way to do a universal fix of this on the SQL file or similar?
Note on the installation:
-- I completely failed to get php.ini working to allow uploads greater than 2MB. (I have a copy in my htdocs folder, but PHP doesn't find it in info.php). So the way I migrated was a work around (which might be a bad one)
-- Backed up the SQL
-- Installed WP 2.8.6 on new server
-- Imported old SQL DB using phpMyadmin
-- Upgraded WP 2.8.6 to 3.0.1