/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 votes203 views3 answers
Sql interview query questions
SQL
0 vote180 views1 answer
Qt qsql check if table exist
SQL
0 vote186 views3 answers
Sql drop all tables
SQL
1 vote187 views2 answers
Test sqlsrv connection
SQL
1 vote179 views1 answer
Woocommerce mysql price table
SQL
5 votes173 views2 answers
Ranking functions in sql
SQL
1 vote181 views1 answer
How to find median of a column sql
SQL
6 votes205 views1 answer
How to get the size of the database in postgresql
SQL
0 vote185 views1 answer
Add sqlite3 in lumen
SQL
0 vote180 views1 answer
Sql insert query list of dictionaries
SQL