/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 vote199 views1 answer
Connect to ssms with python
SQL
0 vote209 views1 answer
Alter domain sql
SQL
1 vote175 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote178 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote180 views1 answer
Eliminar ultimo carcacter mysql
SQL
3 votes206 views3 answers
Update con select postgresql
SQL
1 vote203 views3 answers
Postgresql get difference between two dates
SQL
1 vote301 views1 answer
Mysql breakline on string
SQL
1 vote172 views1 answer
Sql select all from one table and one column from another
SQL
0 vote199 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL