/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 vote279 views1 answer
Sql string contains case sensitive
SQL
1 vote249 views1 answer
Insert into sql
SQL
0 vote358 views2 answers
Mysql insert rows to another database
SQL
2 votes289 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote264 views2 answers
Avg() sql
SQL
4 votes288 views2 answers
Postgre sql create table
SQL
3 votes374 views1 answer
Sql select second max
SQL
5 votes300 views2 answers
Sql server port number
SQL
0 vote277 views2 answers
Get all index postgres
SQL
5 votes338 views2 answers
How to ascending order in sql
SQL