How to change collation of database, table, column?

You need to either convert each table individually:

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4

(this will convert the columns just as well), or export the database with latin1 and import it back with utf8mb4.

Related Posts:

  1. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  2. Unknown collation when I import a dump from an existing site into a development database?
  3. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. MySQL error 2006: mysql server has gone away
  6. Which MySQL data type to use for storing boolean values
  7. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  8. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  9. Your password does not satisfy the current policy requirements
  10. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  11. what does “/index.php?admin/admin_dashboard” in my url mean
  12. How to join two tables by multiple columns in SQL?
  13. How to get size of mysql database?
  14. Selecting data from two different tables without using joins
  15. SQL – Update multiple records in one query
  16. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  17. mysqladmin: connect to server at ‘localhost’ failed
  18. mysql update multiple columns with same now()
  19. Usage of MySQL’s “IF EXISTS”
  20. How can I loop through all rows of a table? (MySQL)
  21. Generating a random & unique 8 character string using MySQL
  22. MySQL > Table doesn’t exist. But it does (or it should)
  23. SQL select only rows with max value on a column
  24. Trying to perform MINUS operation in MySQL
  25. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  26. mysql count duplicates
  27. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  28. MySQL config file location – redhat linux server
  29. How to create a foreign key in phpmyadmin
  30. Failed building wheel for mysql-python
  31. Create boolean column in MySQL with false as default value?
  32. Is there a naming convention for MySQL?
  33. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  34. MySql – HAVING vs WHERE 
  35. How to stop mysqld
  36. mysql: connection refused when trying to connect to localhost using remote IP
  37. Is merge statement available in MySQL
  38. GROUP_CONCAT comma separator – MySQL
  39. Complex meta query with 3 keys
  40. Set page template for all pages?
  41. Optimize Multiple Taxonomy Term MySQL Query?
  42. WordPress MySQL & PHP Performance
  43. What specific database privileges does WordPress need?
  44. Using source control with WordPress
  45. My WordPress site always displays a cached version of its homepage
  46. Updating User Meta with SQL Query
  47. wpdb prepare syntax
  48. How to run this SQL query of wp_terms database
  49. Configure WordPress to connect to Mysql DB using SSH tunneling
  50. Proper way to work with wpdb to get user’s firstname
  51. How to change post format from Aside to Image for all posts?
  52. Inserting Hundreds of Thousands of Posts at Once
  53. wp_admin edit.php slow with lots of queries
  54. How to add and SQL query of posts only published
  55. Slow Mysql Queries
  56. can database and media folder be moved to a different drive?
  57. Find duplicate posts with same slug and author
  58. Rewrite database urls
  59. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  60. writing inner join in wpdb
  61. How to get data from WordPress site sql file
  62. PHP script can’t connect to Database on port 3307
  63. WordPress with php5-fpm and nginx
  64. How to split the a table in database?
  65. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  66. How to translate this mySQL query to $wpdb query
  67. $wpdb to insert html form information
  68. Proper usage of $wpdb->update()?
  69. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  70. Separate DB by yearly archive of WordPress
  71. What should a WordPress developer know about MySQL? [closed]
  72. Copyright: Get first and last date of post type
  73. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  74. Update MySQL query so that it functions again
  75. Query posts by custom taxonomy and sort by post_modified
  76. WordPress $wpdb get posts from category and sort by custom meta
  77. WordPress tables and aliases?
  78. What’s the sql for this condition?
  79. Copy usermeta value where ID matches in the same table
  80. Array Formation Issue
  81. How can I write a formal sql query to get data from a custom table
  82. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  83. WordPress $wpdb no result
  84. User set date and time from frontend doesn’t get stored into database
  85. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  86. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  87. edit_user_created_user hook – using to update Groups
  88. Changes not being reflected on new server
  89. Mysql Error in querying form entries in Gravity Form plugin
  90. Improving performance of SQL sub-queries in WordPress
  91. Saving custom term value to the database in new table
  92. MySQL errors after a WordPress clone
  93. MYSQL Join on meta key value?
  94. Woocommerce: Grab total revenue of a product over all orders
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment

tech