Skip to content

Instantly share code, notes, and snippets.

@deltaepsilon
Created September 18, 2013 20:33
Show Gist options
  • Save deltaepsilon/6615248 to your computer and use it in GitHub Desktop.
Save deltaepsilon/6615248 to your computer and use it in GitHub Desktop.
Sometimes WordPress needs some DB love. Convert tables to use utf8 so PHP will stop throwing errors.
alter table wp_ak_twitter convert to character set utf8 collate utf8_general_ci;
alter table wp_banner convert to character set utf8 collate utf8_general_ci;
alter table wp_commentmeta convert to character set utf8 collate utf8_general_ci;
alter table wp_comments convert to character set utf8 collate utf8_general_ci;
alter table wp_links convert to character set utf8 collate utf8_general_ci;
alter table wp_ngg_album convert to character set utf8 collate utf8_general_ci;
alter table wp_ngg_gallery convert to character set utf8 collate utf8_general_ci;
alter table wp_ngg_pictures convert to character set utf8 collate utf8_general_ci;
alter table wp_options convert to character set utf8 collate utf8_general_ci;
alter table wp_pollsa convert to character set utf8 collate utf8_general_ci;
alter table wp_pollsip convert to character set utf8 collate utf8_general_ci;
alter table wp_pollsq convert to character set utf8 collate utf8_general_ci;
alter table wp_popularpostsdata convert to character set utf8 collate utf8_general_ci;
alter table wp_popularpostsdatacache convert to character set utf8 collate utf8_general_ci;
alter table wp_postmeta convert to character set utf8 collate utf8_general_ci;
alter table wp_posts convert to character set utf8 collate utf8_general_ci;
alter table wp_sodahead_user convert to character set utf8 collate utf8_general_ci;
alter table wp_tantan_wordpress_s3_cache convert to character set utf8 collate utf8_general_ci;
alter table wp_term_relationships convert to character set utf8 collate utf8_general_ci;
alter table wp_term_taxonomy convert to character set utf8 collate utf8_general_ci;
alter table wp_terms convert to character set utf8 collate utf8_general_ci;
alter table wp_usermeta convert to character set utf8 collate utf8_general_ci;
alter table wp_users convert to character set utf8 collate utf8_general_ci;
alter table wp_woo_custom_nav_menus convert to character set utf8 collate utf8_general_ci;
alter table wp_woo_custom_nav_records convert to character set utf8 collate utf8_general_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment