/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 vote325 views1 answer
Sql select min row
SQL
0 vote344 views1 answer
Postgresql auto increment not working
SQL
7 votes334 views3 answers
How ot change name of column mysql
SQL
19 votes344 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote353 views1 answer
Timestamp(0) postgresql
SQL
0 vote339 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote410 views1 answer
Mysql get max value and id
SQL
1 vote345 views1 answer
Oracle select row max date
SQL
3 votes349 views1 answer
Sql add two values together
SQL
0 vote661 views1 answer
Create pl/sql stored procedure
SQL