Converts the WordPress database (both tables and columns) to UTF-8 character set.
|Author:||Yihui Xie (profile at wordpress.org)|
|WordPress version required:||2.0.2|
|WordPress version tested:||2.8|
|Added to WordPress repository:||20-06-2009|
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|Total downloads:||33 385|
Click to start download
This plugin can convert your WordPress database (both tables and columns) to UTF-8 character set. It will be especially useful when you move your database from one server to another where the default CHARSET is not UTF-8.
What’s happening “behind the scene”?
- Change tables:
ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
- Change columns:
ALTER TABLE $table CHANGE $field_name $field_name $field_type CHARACTER SET utf8 COLLATE utf8_general_ci
What about the WP version?
As you’ve seen, only MySQL and PHP are required. Roughly speaking, it has nothing to do with WordPress, so you can use almost any version of WordPress.
2011-10-14 version 1.0.2
- use COLLATE utf8_general_ci instead of utf8_bin
2009-06-20 version 1.0.0 released