/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

3 votes277 views1 answer
Two select sql
SQL
1 vote279 views1 answer
Mysql select and count left join
SQL
1 vote265 views1 answer
Sql in array query
SQL
0 vote235 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote259 views1 answer
Formatting code with SQL Developer
SQL
0 vote306 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote241 views1 answer
Delete triger pl pg sql
SQL
2 votes320 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote245 views1 answer
Mysql select row with min date
SQL
5 votes252 views2 answers
Oracle show procedures
SQL