Wordpress 2.9.1, beware of encoding issues
I’ve just spent an hour and a half upgrading to Wordpress 2.9.1. Why did it take that long? Well, their database upgrade assigned the wrong collation to the fields in the database, rendering all the double-byte characters in my posts as ???. Very annoying and a pretty major oversite for such a widely adopted piece of software.
After searching around the Wordpress Forums, I found this post which blames the Gengo plugin for these encoding problems: [Plugin: Gengo] characters showing as ?????.
What was the solution? Open up phpMyAdmin. and:
1. Change the collation for each table to “utf8_general_ci”
2. Change the collation of the offending fields to “utf8_general_ci”
It’s a pain, but it’ll solve the issue. Hopefully, the next Wordpress version will solve this problem.
About this entry
You’re currently reading “Wordpress 2.9.1, beware of encoding issues,” an entry on Asian-Caucasian Issues
- Published:
- 01.10.10 / 2am
- Category:
- Web development
6 Comments
Jump to comment form | comments rss [?] | trackback uri [?]