Difference between revisions of "MySQL"
From Wikicliki
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | == Alter collation of wordpress tables to utf8 == | ||
| + | |||
<pre> | <pre> | ||
ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | ||
| Line 11: | Line 13: | ||
ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; | ||
</pre> | </pre> | ||
| + | |||
| + | 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> | ||
| + | |||
| + | == How to repair table in phpMyAdmin == | ||
| + | |||
| + | [[Image:repairtable.png]] | ||
| + | |||
| + | == Joke == | ||
| + | |||
| + | http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-traffic-cameras | ||
| + | |||
| + | |||
| + | == See Also == | ||
| + | |||
| + | [[Category:Programming]] | ||
Latest revision as of 19:09, 23 August 2013
Contents
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
Joke
http://gizmodo.com/5498412/sql-injection-license-plate-hopes-to-foil-euro-traffic-cameras
