parhelium.pl

Comments (0)

SQL queries to change collation in wordpress

Simple queries to change collation in every table:

ALTER TABLE `wp_commentmeta` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_options` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_postmeta` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_term_relationships` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_term_taxonomy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_terms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_usermeta` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_woo_custom_nav_menus` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;
ALTER TABLE `wp_woo_custom_nav_records` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci;

Comments (1)

Default MySQL character set and collation

Database:
ALTER DATABASE `db1` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci ;

Every table:
ALTER TABLE `table1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci