/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 vote226 views1 answer
Oracle winter time change
SQL
13 votes200 views6 answers
Current date sql
SQL
0 vote197 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote224 views1 answer
Power bi find all ids not in other tables
SQL
1 vote221 views1 answer
Update mysql centos
SQL
1 vote226 views3 answers
Psql fatal database does not exist
SQL
1 vote217 views1 answer
Sql convert month name to number
SQL
1 vote243 views1 answer
Oracle columns table
SQL
0 vote192 views1 answer
Sql composite key
SQL
0 vote198 views1 answer
Mysql jdbc timezone
SQL