How to change collation of database, table, column?

by

I am contributing here, as the OP asked:

How to change collation of database, table, column?

The selected answer just states it on table level.

Changing it database wide:

ALTER DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Changing it per table:

ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Good practice is to change it at table level as it’ll change it for columns as well. Changing for specific column is for any specific case.

Changing collation for a specific column:

ALTER TABLE <table_name> MODIFY <column_name> VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

More Related Contents:

  1. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  2. Troubleshooting “Illegal mix of collations” error in mysql
  3. UTF-8: General? Bin? Unicode?
  4. How to change the CHARACTER SET (and COLLATION) throughout a database?
  5. What effects does using a binary collation have?
  6. Are column and table name case sensitive in MySQL?
  7. Illegal mix of collations error in MySql
  8. What is the best MySQL collation for German language
  9. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  10. MySQL treats ÅÄÖ as AAO?
  11. How to change the default charset of a MySQL table?
  12. MySQL Illegal mix of collations
  13. SELECTING with multiple WHERE conditions on same column
  14. grant remote access of MySQL database from any IP address
  15. Should MySQL have its timezone set to UTC?
  16. JDBC batch insert performance
  17. SQL – Update multiple records in one query
  18. How to find gaps in sequential numbering in mysql?
  19. Can I create view with parameter in MySQL?
  20. MySQL: Invalid use of group function
  21. OUTPUT Clause in MySQL
  22. MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?
  23. Import MySQL dump to PostgreSQL database
  24. How to select data where a field has a min value in MySQL?
  25. Database corruption with MariaDB : Table doesn’t exist in engine
  26. MYSQL declaring variables
  27. get a recursive parent list
  28. MYSQL – Split Data Into Multiple Rows
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment