/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 vote348 views1 answer
Compare strings lexicographically in sql
SQL
0 vote245 views1 answer
Version and edition of SQL Server Database Engine
SQL
14 votes269 views2 answers
Oracle add attribute to table
SQL
0 vote287 views2 answers
How to install psql in ubuntu
SQL
0 vote262 views1 answer
Sql stored procedure update if parameter is not null
SQL
6 votes253 views2 answers
Database url postgres
SQL
25 votes255 views3 answers
Mysql command show tables
SQL
0 vote297 views1 answer
FIND most frequent word in sql server
SQL
0 vote266 views1 answer
Resullt all update knex mysql
SQL
8 votes278 views1 answer
Ltrim sql
SQL