/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 vote345 views1 answer
Media sql
SQL
0 vote429 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote344 views1 answer
SQL Error 1040 : Too many connections
SQL
1 vote391 views2 answers
Truncate table sqlite
SQL
0 vote361 views1 answer
Oracle sql log to console
SQL
0 vote343 views4 answers
Mysql select bottom 10 rows
SQL
12 votes378 views4 answers
How to check mysql version ubuntu
SQL
6 votes369 views3 answers
Mysql create database utf8
SQL
0 vote411 views1 answer
Sql basic commands
SQL
18 votes355 views3 answers
Find column name in database
SQL