/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 vote160 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
3 votes254 views2 answers
Find string in stored procedure sql server
SQL
3 votes183 views1 answer
What is having clause
SQL
3 votes197 views1 answer
Laravel database Using Named Bindings
SQL
0 vote185 views2 answers
Sql count number of rows after group by
SQL
1 vote211 views1 answer
Oracle lowercase
SQL
0 vote196 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote188 views2 answers
Sql drop view if exists
SQL
1 vote226 views1 answer
Ubuntu access database from terminal
SQL
0 vote207 views2 answers
Reseed sql identity
SQL