/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 vote112 views1 answer
Get sum sqlite android
SQL
1 vote121 views3 answers
Mysql connection string
SQL
0 vote119 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote166 views1 answer
Sqlalchemy orm duplicate
SQL
29 votes115 views5 answers
Mysql show table structure
SQL
0 vote192 views1 answer
Bigrock database connection string
SQL
5 votes126 views2 answers
Oracle tables with column name
SQL
1 vote147 views1 answer
Oracle grant select on schema
SQL
1 vote127 views1 answer
Mysql last year
SQL
0 vote124 views2 answers
What is 1=2 in sql
SQL