{"name":"Convert WP Database to UTF-8","slug":"utf-8-db-converter","version":"1.0.2","author":"Yihui Xie","author_profile":"https://profiles.wordpress.org/yihui/","requires":"2.0.2","tested":"2.8","requires_php":false,"requires_plugins":[],"rating":100,"ratings":{"1":0,"2":0,"3":0,"4":0,"5":4},"num_ratings":4,"support_threads":0,"support_threads_resolved":0,"downloaded":35340,"last_updated":"2011-10-14 7:53pm GMT","added":"2009-06-20","homepage":"http://yihui.name/en/2009/05/convert-mysql-database-to-utf-8-in-wordpress/","sections":{"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.

\n","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 the Plugins menu
Follow the instructions – Done!

\n","faq":"\n

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.

\n\n","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

\n","screenshots":"

$\"Admin$
Admin interface

"},"download_link":"https://downloads.wordpress.org/plugin/utf-8-db-converter.zip","screenshots":{"1":{"src":"https://ps.w.org/utf-8-db-converter/trunk/screenshot-1.png?rev=1538857","caption":"Admin interface"}},"tags":{"charset":"charset","converter":"converter","database":"database","mysql":"mysql","utf-8":"utf-8"},"versions":[],"donate_link":"http://yihui.name","icons":{"default":"https://s.w.org/plugins/geopattern-icon/utf-8-db-converter.svg"},"contributors":{"yihui":"https://profiles.wordpress.org/yihui/"}}

Convert WP Database to UTF-8

Screenshots

Categories

Get New Themes & Resources