Difference between revisions of "MySQL"
From Wikicliki
| Line 16: | Line 16: | ||
the default is latin_swedish cos mysql is made in sweden! | the default is latin_swedish cos mysql is made in sweden! | ||
| − | + | NEW ADDITION - i think this one is new category added in new WP? | |
| − | |||
<Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | <Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | ||
Revision as of 09:08, 16 July 2011
Alter collation of wordpress tables to utf8
ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_links` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_options` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_postmeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_terms` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_term_relationships` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_term_taxonomy` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_usermeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
the default is latin_swedish cos mysql is made in sweden!
NEW ADDITION - i think this one is new category added in new WP?
ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
How to repair table in phpMyAdmin
