Illegal mix of collations MySQL Error

by 
SET collation_connection = 'utf8_general_ci';

then for your databases

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL sneaks swedish in there sometimes for no sensible reason.

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. multiple query same table but in different columns mysql
  3. How can I make SQL case sensitive string comparison on MySQL?
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to split the name string in mysql?
  7. Count the occurrences of DISTINCT values
  8. SQL: selecting rows where column value changed from previous row
  9. Cast int to varchar
  10. How to generate data in MySQL?
  11. SQL query of multiple values in one cell
  12. Import SQL file into mysql
  13. MySQL SELECT last few days?
  14. How to skip certain database tables with mysqldump?
  15. “where 1=1” statement [duplicate]
  16. MySQL error 1241: Operand should contain 1 column(s)
  17. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  18. Mysql: Order by like?
  19. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  20. How to get a list of months between two dates in mysql
  21. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  22. Postgres LEFT JOIN with WHERE condition
  23. How to format number with “.” as thousands separator and “,” as decimal separator?
  24. Using DISTINCT and COUNT together in a MySQL Query
  25. How to check if field is null or empty in MySQL?
  26. MySQL OPTIMIZE all tables?
  27. Strip last two characters of a column in MySQL
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment