Illegal mix of collations error in MySql

by

Here’s how to check which columns are the wrong collation:

SELECT table_schema, table_name, column_name, character_set_name, collation_name

FROM information_schema.columns

WHERE collation_name="latin1_general_ci"

ORDER BY table_schema, table_name,ordinal_position;

And here’s the query to fix it:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET latin1 COLLATE 'latin1_swedish_ci';

Link

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. Illegal mix of collations MySQL Error
  5. How to change the CHARACTER SET (and COLLATION) throughout a database?
  6. How to change collation of database, table, column?
  7. What effects does using a binary collation have?
  8. Are column and table name case sensitive in MySQL?
  9. What is the best MySQL collation for German language
  10. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  11. MySQL treats ÅÄÖ as AAO?
  12. How to change the default charset of a MySQL table?
  13. MySQL Illegal mix of collations
  14. How to store Emoji Character in MySQL Database
  15. Any way to select without causing locking in MySQL?
  16. Log all queries in mysql
  17. Truncate all tables in a MySQL database in one command?
  18. Cast from VARCHAR to INT – MySQL
  19. How to convert result table to JSON array in MySQL
  20. Adding multiple columns AFTER a specific column in MySQL
  21. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  22. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  23. Terminating idle mysql connections
  24. mysql DECLARE WHILE outside stored procedure how?
  25. MySql Single Table, Select last 7 days and include empty rows
  26. How can I check MySQL engine type for a specific table?
  27. mysql SQL: specific item to be first and then to sort the rest of the items
  28. When is a timestamp (auto) updated?
  29. Should I normalize my DB or not?
  30. How do you force mysql LIKE to be case sensitive? [duplicate]

Leave a Comment