Difference between revisions of "MySQL"

From Wikicliki
Jump to: navigation, search
Line 15: Line 15:
  
 
the default is latin_swedish cos mysql is made in sweden!
 
the default is latin_swedish cos mysql is made in sweden!
 +
 +
 +
NEWWWWW
 +
 +
<Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
 +
</pre>

Revision as of 18:03, 15 September 2010

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!


NEWWWWW

ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;