/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

24 votes148 views4 answers
Postgres remove database
SQL
0 vote158 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote110 views1 answer
Finish transaction sql
SQL
0 vote144 views1 answer
Postgres copy command
SQL
0 vote142 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote153 views1 answer
Get rows from 1 table with other table empty mysql
SQL
14 votes150 views2 answers
Oracle export trigger ddl
SQL
0 vote149 views1 answer
Allow external access to mysql
SQL
0 vote137 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote146 views1 answer
Table values functions in SQL
SQL