/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 vote194 views1 answer
Apache Derby: Create SQL Dump with data
SQL
6 votes210 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
2 votes228 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote205 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
5 votes191 views5 answers
Sqlite install python
SQL
0 vote275 views1 answer
Mysql loop through databases and execute query
SQL
0 vote239 views1 answer
Sql server datetime
SQL
0 vote233 views1 answer
List all permissions on a table in postgres
SQL
0 vote203 views1 answer
Cast float mysql
SQL
0 vote204 views1 answer
Add SuperUser MySQL
SQL