/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 vote284 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote236 views1 answer
Sql new line output
SQL
2 votes275 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote282 views1 answer
Mysql terminal run sql file
SQL
1 vote333 views1 answer
Delete dublicate rows sql
SQL
0 vote291 views1 answer
Sql if clause within where clause
SQL
0 vote315 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote283 views1 answer
Last date for each user sql
SQL
0 vote281 views1 answer
Mysql workbench indent formatting
SQL
1 vote228 views1 answer
Mysql see column types
SQL