Transfer

This entry was posted by on Thursday, 12 March, 2009 at

As you can see the site has transfered ok, apart from wordpress 2.7.1 doesn’t like japanese characters, they all just show up as 「九つ」- if they change from ? marks to characters then I suppose it’s been fixed.

———————– UPDATE ———————–

Well all it took was a little phpMyAdmin editing, going through and changing every collation entry on the database. Just in case you have the same problem, a quick run down of what to do if Japanese, Chinese or other foreign characters will not display on your wordpress page. Going into each database main folder, e.g. “wp_posts”, changing each instance of “latin1_general_ci” or whatever it may be, to “utf8_general_ci” on the “Structure” tab. Now do the same on the “Operations” tab in the “Table Options” section. All you need to do now is re-enter any characters that have been replaced with question marks in your posts. I probably made it sound easy and safe, though it wasn’t that difficult, as I figured this out just stumbling around the phpMyAdmin section. I didn’t, but would advise on backing up any and all database entries first.


Leave a Reply