Convert Database to UTF8

This script generates SQL to convert existing tables to utf8, following the guide at http://codex.wordpress.org/Converting_Database_Character_Sets, temporarily setting various fields to BLOB before setting them back to their respective types.

Please note that you probably will get some errors running the scripts, regarding key length on some tables. These errors can be ignored (at least I did :).

ALTER TABLE commentmeta MODIFY meta_key BLOB;
ALTER TABLE commentmeta MODIFY meta_value BLOB;
ALTER TABLE comments MODIFY comment_author BLOB;
ALTER TABLE comments MODIFY comment_author_email BLOB;
ALTER TABLE comments MODIFY comment_author_url BLOB;
ALTER TABLE comments MODIFY comment_author_IP BLOB;
ALTER TABLE comments MODIFY comment_content BLOB;
ALTER TABLE comments MODIFY comment_approved BLOB;
ALTER TABLE comments MODIFY comment_agent BLOB;
ALTER TABLE comments MODIFY comment_type BLOB;
ALTER TABLE geo_mashup_administrative_names MODIFY country_code BLOB;
ALTER TABLE geo_mashup_administrative_names MODIFY admin_code BLOB;
ALTER TABLE geo_mashup_administrative_names MODIFY isolanguage BLOB;
ALTER TABLE geo_mashup_administrative_names MODIFY name BLOB;
ALTER TABLE geo_mashup_location_relationships MODIFY object_name BLOB;
ALTER TABLE geo_mashup_locations MODIFY address BLOB;
ALTER TABLE geo_mashup_locations MODIFY saved_name BLOB;
ALTER TABLE geo_mashup_locations MODIFY geoname BLOB;
ALTER TABLE geo_mashup_locations MODIFY postal_code BLOB;
ALTER TABLE geo_mashup_locations MODIFY country_code BLOB;
ALTER TABLE geo_mashup_locations MODIFY admin_code BLOB;
ALTER TABLE geo_mashup_locations MODIFY sub_admin_code BLOB;
ALTER TABLE geo_mashup_locations MODIFY locality_name BLOB;
ALTER TABLE links MODIFY link_url BLOB;
ALTER TABLE links MODIFY link_name BLOB;
ALTER TABLE links MODIFY link_image BLOB;
ALTER TABLE links MODIFY link_target BLOB;
ALTER TABLE links MODIFY link_description BLOB;
ALTER TABLE links MODIFY link_visible BLOB;
ALTER TABLE links MODIFY link_rel BLOB;
ALTER TABLE links MODIFY link_notes BLOB;
ALTER TABLE links MODIFY link_rss BLOB;
ALTER TABLE openid_identities MODIFY hash BLOB;
ALTER TABLE options MODIFY option_name BLOB;
ALTER TABLE options MODIFY option_value BLOB;
ALTER TABLE options MODIFY autoload BLOB;
ALTER TABLE postmeta MODIFY meta_key BLOB;
ALTER TABLE postmeta MODIFY meta_value BLOB;
ALTER TABLE posts MODIFY post_content BLOB;
ALTER TABLE posts MODIFY post_title BLOB;
ALTER TABLE posts MODIFY post_excerpt BLOB;
ALTER TABLE posts MODIFY post_status BLOB;
ALTER TABLE posts MODIFY comment_status BLOB;
ALTER TABLE posts MODIFY ping_status BLOB;
ALTER TABLE posts MODIFY post_password BLOB;
ALTER TABLE posts MODIFY post_name BLOB;
ALTER TABLE posts MODIFY to_ping BLOB;
ALTER TABLE posts MODIFY pinged BLOB;
ALTER TABLE posts MODIFY post_content_filtered BLOB;
ALTER TABLE posts MODIFY guid BLOB;
ALTER TABLE posts MODIFY post_type BLOB;
ALTER TABLE posts MODIFY post_mime_type BLOB;
ALTER TABLE term_taxonomy MODIFY taxonomy BLOB;
ALTER TABLE term_taxonomy MODIFY description BLOB;
ALTER TABLE terms MODIFY name BLOB;
ALTER TABLE terms MODIFY slug BLOB;
ALTER TABLE usermeta MODIFY meta_key BLOB;
ALTER TABLE usermeta MODIFY meta_value BLOB;
ALTER TABLE users MODIFY user_login BLOB;
ALTER TABLE users MODIFY user_pass BLOB;
ALTER TABLE users MODIFY user_nicename BLOB;
ALTER TABLE users MODIFY user_email BLOB;
ALTER TABLE users MODIFY user_url BLOB;
ALTER TABLE users MODIFY user_activation_key BLOB;
ALTER TABLE users MODIFY display_name BLOB;
ALTER DATABASE dnghublog charset=utf8;
ALTER TABLE commentmeta charset=utf8;
ALTER TABLE comments charset=utf8;
ALTER TABLE geo_mashup_administrative_names charset=utf8;
ALTER TABLE geo_mashup_location_relationships charset=utf8;
ALTER TABLE geo_mashup_locations charset=utf8;
ALTER TABLE links charset=utf8;
ALTER TABLE openid_identities charset=utf8;
ALTER TABLE options charset=utf8;
ALTER TABLE postmeta charset=utf8;
ALTER TABLE posts charset=utf8;
ALTER TABLE term_relationships charset=utf8;
ALTER TABLE term_taxonomy charset=utf8;
ALTER TABLE terms charset=utf8;
ALTER TABLE usermeta charset=utf8;
ALTER TABLE users charset=utf8;
ALTER TABLE commentmeta MODIFY meta_key varchar(255);
ALTER TABLE commentmeta MODIFY meta_value longtext;
ALTER TABLE comments MODIFY comment_author tinytext;
ALTER TABLE comments MODIFY comment_author_email varchar(100);
ALTER TABLE comments MODIFY comment_author_url varchar(200);
ALTER TABLE comments MODIFY comment_author_IP varchar(100);
ALTER TABLE comments MODIFY comment_content text;
ALTER TABLE comments MODIFY comment_approved varchar(20);
ALTER TABLE comments MODIFY comment_agent varchar(255);
ALTER TABLE comments MODIFY comment_type varchar(20);
ALTER TABLE geo_mashup_administrative_names MODIFY country_code varchar(2);
ALTER TABLE geo_mashup_administrative_names MODIFY admin_code varchar(20);
ALTER TABLE geo_mashup_administrative_names MODIFY isolanguage varchar(7);
ALTER TABLE geo_mashup_administrative_names MODIFY name varchar(200);
ALTER TABLE geo_mashup_location_relationships MODIFY object_name varchar(80);
ALTER TABLE geo_mashup_locations MODIFY address tinytext;
ALTER TABLE geo_mashup_locations MODIFY saved_name varchar(100);
ALTER TABLE geo_mashup_locations MODIFY geoname tinytext;
ALTER TABLE geo_mashup_locations MODIFY postal_code tinytext;
ALTER TABLE geo_mashup_locations MODIFY country_code varchar(2);
ALTER TABLE geo_mashup_locations MODIFY admin_code varchar(20);
ALTER TABLE geo_mashup_locations MODIFY sub_admin_code varchar(80);
ALTER TABLE geo_mashup_locations MODIFY locality_name tinytext;
ALTER TABLE links MODIFY link_url varchar(255);
ALTER TABLE links MODIFY link_name varchar(255);
ALTER TABLE links MODIFY link_image varchar(255);
ALTER TABLE links MODIFY link_target varchar(25);
ALTER TABLE links MODIFY link_description varchar(255);
ALTER TABLE links MODIFY link_visible varchar(20);
ALTER TABLE links MODIFY link_rel varchar(255);
ALTER TABLE links MODIFY link_notes mediumtext;
ALTER TABLE links MODIFY link_rss varchar(255);
ALTER TABLE openid_identities MODIFY hash char(32);
ALTER TABLE options MODIFY option_name varchar(64);
ALTER TABLE options MODIFY option_value longtext;
ALTER TABLE options MODIFY autoload varchar(20);
ALTER TABLE postmeta MODIFY meta_key varchar(255);
ALTER TABLE postmeta MODIFY meta_value longtext;
ALTER TABLE posts MODIFY post_content longtext;
ALTER TABLE posts MODIFY post_title text;
ALTER TABLE posts MODIFY post_excerpt text;
ALTER TABLE posts MODIFY post_status varchar(20);
ALTER TABLE posts MODIFY comment_status varchar(20);
ALTER TABLE posts MODIFY ping_status varchar(20);
ALTER TABLE posts MODIFY post_password varchar(20);
ALTER TABLE posts MODIFY post_name varchar(200);
ALTER TABLE posts MODIFY to_ping text;
ALTER TABLE posts MODIFY pinged text;
ALTER TABLE posts MODIFY post_content_filtered text;
ALTER TABLE posts MODIFY guid varchar(255);
ALTER TABLE posts MODIFY post_type varchar(20);
ALTER TABLE posts MODIFY post_mime_type varchar(100);
ALTER TABLE term_taxonomy MODIFY taxonomy varchar(32);
ALTER TABLE term_taxonomy MODIFY description longtext;
ALTER TABLE terms MODIFY name varchar(200);
ALTER TABLE terms MODIFY slug varchar(200);
ALTER TABLE usermeta MODIFY meta_key varchar(255);
ALTER TABLE usermeta MODIFY meta_value longtext;
ALTER TABLE users MODIFY user_login varchar(60);
ALTER TABLE users MODIFY user_pass varchar(64);
ALTER TABLE users MODIFY user_nicename varchar(50);
ALTER TABLE users MODIFY user_email varchar(100);
ALTER TABLE users MODIFY user_url varchar(100);
ALTER TABLE users MODIFY user_activation_key varchar(60);
ALTER TABLE users MODIFY display_name varchar(250);