Created
September 18, 2013 20:33
-
-
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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