/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

7 votes174 views3 answers
Add primary key to database sql
SQL
8 votes193 views1 answer
Mysql limit rows
SQL
2 votes186 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
4 votes198 views3 answers
Is not null sql
SQL
0 vote236 views1 answer
Install squirrel sql ubuntu
SQL
0 vote182 views1 answer
Oracle create table auto generated primary key
SQL
1 vote185 views2 answers
Postgresql remote connect
SQL
0 vote243 views1 answer
Plpgsql create function
SQL
0 vote185 views1 answer
Sql select non unique
SQL
0 vote192 views1 answer
Trigger vérifier stock
SQL