Title: Convert WP Database to UTF-8 Author: yihui Published: June 20, 2009 Last modified: October 14, 2011 --- Search plugins This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://s.w.org/plugins/geopattern-icon/utf-8-db-converter.svg) # Convert WP Database to UTF-8 By [yihui](https://profiles.wordpress.org/yihui/) [Download](https://downloads.wordpress.org/plugin/utf-8-db-converter.zip) * [Details](https://wordpress.org/plugins/utf-8-db-converter/#description) * [Reviews](https://wordpress.org/plugins/utf-8-db-converter/#reviews) * [Installation](https://wordpress.org/plugins/utf-8-db-converter/#installation) * [Development](https://wordpress.org/plugins/utf-8-db-converter/#developers) [Support](https://wordpress.org/support/plugin/utf-8-db-converter/) ## 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 * [[ * Admin interface ## Installation 1. Upload the directory `utf-8-db-converter` to the `/wp-content/plugins/` directory 2. Activate the plugin through the `Plugins` menu in WordPress 3. Then you’ll see the sub-menu `UTF-8 DB Converter` under the `Plugins` menu 4. Follow the instructions – Done! ## FAQ What’s happening “behind the scene”? 1. Change tables: `ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci` 2. 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. ## Reviews ![](https://secure.gravatar.com/avatar/015a4e9d3e4f0bf048a022315b50550ea8a6c60a0e9455be60826e22bae1287c? s=60&d=retro&r=g) ### 󠀁[Good work](https://wordpress.org/support/topic/good-work-302/)󠁿 [papacoderrs](https://profiles.wordpress.org/papacoderrs/) September 3, 2016 Thank you! [ Read all 4 reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/) ## Contributors & Developers “Convert WP Database to UTF-8” is open source software. The following people have contributed to this plugin. Contributors * [ yihui ](https://profiles.wordpress.org/yihui/) [Translate “Convert WP Database to UTF-8” into your language.](https://translate.wordpress.org/projects/wp-plugins/utf-8-db-converter) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/utf-8-db-converter/), check out the [SVN repository](https://plugins.svn.wordpress.org/utf-8-db-converter/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/utf-8-db-converter/) by [RSS](https://plugins.trac.wordpress.org/log/utf-8-db-converter/?limit=100&mode=stop_on_copy&format=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 ## Meta * Version **1.0.2** * Last updated **15 years ago** * Active installations **300+** * WordPress version ** 2.0.2 or higher ** * Tested up to **2.8** * Tags * [converter](https://wordpress.org/plugins/tags/converter/)[database](https://wordpress.org/plugins/tags/database/) [mysql](https://wordpress.org/plugins/tags/mysql/)[utf-8](https://wordpress.org/plugins/tags/utf-8/) * [Advanced View](https://wordpress.org/plugins/utf-8-db-converter/advanced/) ## Ratings 5 out of 5 stars. * [ 4 5-star reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/utf-8-db-converter/reviews/) ## Contributors * [ yihui ](https://profiles.wordpress.org/yihui/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/utf-8-db-converter/) ## Donate Would you like to support the advancement of this plugin? [ Donate to this plugin ](http://yihui.name)