Description
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.
Screenshots
Installation
- Upload the directory
utf-8-db-converter
to the/wp-content/plugins/
directory - Activate the plugin through the
Plugins
menu in WordPress - Then you’ll see the sub-menu
UTF-8 DB Converter
under thePlugins
menu - Follow the instructions — Done!
FAQ
- 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
- Change tables:
- 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.
Contributors & Developers
“Convert WP Database to UTF-8” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “Convert WP Database to UTF-8” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
2011-10-14 version 1.0.2
- use COLLATE utf8_general_ci instead of utf8_bin
2009-06-20 version 1.0.0 released