/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

2 votes284 views1 answer
Sql server case sensitive search
SQL
0 vote264 views1 answer
Why mysql is used?
SQL
0 vote277 views1 answer
Split string by comma in sql server
SQL
0 vote255 views1 answer
Recursive query herarchical data sql server
SQL
0 vote265 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote261 views2 answers
DROP TABLes regardless of constraints
SQL
38 votes322 views6 answers
Alter table mysql
SQL
1 vote293 views2 answers
Oracle leftmost characters
SQL
0 vote280 views1 answer
Clear query cache sql server
SQL
0 vote283 views1 answer
Check if record exists mysql
SQL