/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

4 votes129 views2 answers
Oracle last day of month
SQL
1 vote126 views1 answer
Mysql connect bash
SQL
0 vote122 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote130 views1 answer
Systemverilog unique constraint unique values
SQL
2 votes132 views2 answers
Insert all in sql
SQL
0 vote125 views1 answer
Oracle service name view
SQL
0 vote148 views1 answer
Mysql subtract month from timestamp
SQL
0 vote129 views1 answer
C# get sql min date
SQL
0 vote164 views1 answer
Stop and start mysql
SQL
0 vote165 views1 answer
Sql query to select even numbers
SQL