/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 votes226 views3 answers
Sql max value in column
SQL
0 vote226 views1 answer
Sql query to return field name of a table
SQL
0 vote219 views1 answer
Sql select with apostrohpe
SQL
0 vote215 views1 answer
Select last 2 characters sql
SQL
1 vote193 views1 answer
Delete triger pl pg sql
SQL
19 votes223 views5 answers
Mysql between date range
SQL
0 vote217 views2 answers
How to combine diff colmun value using group by postgres
SQL
16 votes254 views3 answers
T-SQL Add Column
SQL
0 vote233 views1 answer
Write SQL in ruby on rails
SQL
0 vote197 views1 answer
Sql examples from your work
SQL