/SQL/Mysql illegal mix of collations for operation 'join'

Mysql illegal mix of collations for operation 'join'

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; 

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

Source: interworks.com

Similar codes

12 votes382 views5 answers
Rename table in mysql
SQL
-1 vote358 views2 answers
First letter capital in mysql query
SQL
0 vote367 views1 answer
Kill slow queries mysql
SQL
0 vote387 views1 answer
Disable database droping sql
SQL
1 vote342 views1 answer
Get last week data in mysql
SQL
3 votes349 views3 answers
Update join
SQL
0 vote387 views2 answers
How to get max from each department in sql
SQL
0 vote357 views1 answer
Into operator in sql
SQL
2 votes353 views1 answer
SQL IF ELSE
SQL
0 vote330 views1 answer
Find number of entries sql
SQL