/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

0 vote113 views1 answer
How to check replication lag in mySQL
SQL
0 vote123 views1 answer
How to get button for every record from mysql
SQL
0 vote134 views1 answer
Mariadb disable foreign key checks
SQL
4 votes126 views3 answers
Rename table column postgresql
SQL
0 vote62 views1 answer
Oracle sql developer script output limit
SQL
0 vote94 views1 answer
Jooq finding lastest value in table
SQL
-1 vote140 views1 answer
Add 10 to all numbers in a column sql
SQL
1 vote108 views1 answer
Mysql batch insert
SQL
2 votes120 views1 answer
Pdo mysql insert
SQL
0 vote114 views1 answer
Mysql master slave setup with keepalived
SQL