{"id":5724,"date":"2009-06-20T08:02:52","date_gmt":"2009-06-20T08:02:52","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/utf-8-db-converter\/"},"modified":"2011-10-14T19:53:51","modified_gmt":"2011-10-14T19:53:51","slug":"utf-8-db-converter","status":"publish","type":"plugin","link":"https:\/\/azb.wordpress.org\/plugins\/utf-8-db-converter\/","author":3018396,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.0.2","stable_tag":"trunk","tested":"2.8","requires":"2.0.2","requires_php":"","requires_plugins":"","header_name":"Convert WP Database to UTF-8","header_author":"Yihui Xie","header_description":"","assets_banners_color":"","last_updated":"2011-10-14 19:53:51","external_support_url":"","external_repository_url":"","donate_link":"http:\/\/yihui.name","header_plugin_uri":"http:\/\/yihui.name\/en\/2009\/05\/convert-mysql-database-to-utf-8-in-wordpress\/","header_author_uri":"http:\/\/yihui.name\/","rating":5,"author_block_rating":0,"active_installs":300,"downloads":36860,"num_ratings":4,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"4"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1538857","resolution":"1","location":"plugin"}},"screenshots":{"1":"Admin interface"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[31251,5520,153,1627,20687],"plugin_category":[59],"plugin_contributors":[82080],"plugin_business_model":[],"class_list":["post-5724","plugin","type-plugin","status-publish","hentry","plugin_tags-charset","plugin_tags-converter","plugin_tags-database","plugin_tags-mysql","plugin_tags-utf-8","plugin_category-utilities-and-tools","plugin_contributors-yihui","plugin_committers-yihui"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/utf-8-db-converter.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/utf-8-db-converter\/trunk\/screenshot-1.png?rev=1538857","caption":"Admin interface"}],"raw_content":"\n

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.<\/p>\n\n\n

    \n
  1. Upload the directory utf-8-db-converter<\/code> to the \/wp-content\/plugins\/<\/code> directory<\/li>\n
  2. Activate the plugin through the Plugins<\/code> menu in WordPress<\/li>\n
  3. Then you'll see the sub-menu UTF-8 DB Converter<\/code> under the Plugins<\/code> menu<\/li>\n
  4. Follow the instructions - Done!<\/li>\n<\/ol>\n\n\n
    \n
    What's happening \"behind the scene\"?<\/dt>\n
      \n
    1. Change tables: ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci<\/code><\/li>\n
    2. Change columns: ALTER TABLE $table CHANGE $field_name $field_name $field_type CHARACTER SET utf8 COLLATE utf8_general_ci<\/code><\/li>\n<\/ol><\/dd>\n
      What about the WP version?<\/dt>\n

      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.<\/p><\/dd>\n\n<\/dl>\n\n\n

      2011-10-14 version 1.0.2<\/p>\n\n

        \n
      • use COLLATE utf8_general_ci instead of utf8_bin<\/li>\n<\/ul>\n\n

        2009-06-20 version 1.0.0 released<\/p>","raw_excerpt":"Converts the WordPress database (both tables and columns) to UTF-8 character set.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/5724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=5724"}],"author":[{"embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/yihui"}],"wp:attachment":[{"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=5724"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=5724"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=5724"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=5724"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=5724"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/azb.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=5724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}