/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

5 votes130 views4 answers
Describe table postgres
SQL
0 vote138 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote134 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote134 views1 answer
Mysql query single row
SQL
0 vote271 views1 answer
Multiple row join
SQL
0 vote138 views1 answer
Sql server set complex constraints
SQL
1 vote175 views1 answer
Postgresql blocked on mac
SQL
0 vote139 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote142 views1 answer
How to insert multiple rows in mysql using laravel
SQL
-1 vote154 views1 answer
How to Activate the database
SQL