/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 vote135 views1 answer
Oracle sql create or replace view
SQL
0 vote158 views2 answers
Install phoenix
SQL
7 votes230 views2 answers
Sql empty table
SQL
23 votes136 views2 answers
Query to delete a database in mysql
SQL
5 votes144 views3 answers
Sql server utc to local
SQL
1 vote148 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote141 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote156 views2 answers
Sql if empty then
SQL
1 vote129 views3 answers
Union in sql
SQL
0 vote151 views1 answer
Check database restore status sql script
SQL