Difference between revisions of "MySQL"

From Wikicliki
Jump to: navigation, search
 
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 ;  

Revision as of 01:31, 19 June 2009

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 ;