/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

1 vote107 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote117 views4 answers
Open mysql port bitnami tomact
SQL
0 vote117 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
1 vote108 views1 answer
How to fetch alternate records from two tables
SQL
0 vote101 views1 answer
Mysql case when null
SQL
4 votes94 views3 answers
Count with where
SQL
7 votes110 views3 answers
Select latest entry in sql table
SQL
0 vote106 views1 answer
Sql count * vs count 1
SQL
2 votes112 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote116 views1 answer
Trim leading zeros in sql
SQL