/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 vote232 views1 answer
Query archive mode
SQL
4 votes238 views2 answers
Mysql delete user if exists
SQL
2 votes228 views1 answer
Copy all values of a column to another column in sql in same table
SQL
4 votes231 views2 answers
Postgre sql create table
SQL
1 vote249 views1 answer
Opensuse restart MySQL
SQL
36 votes247 views3 answers
Add column in mysq
SQL
0 vote233 views1 answer
Add multiple field in table sql
SQL
3 votes489 views1 answer
Postgresql cast
SQL
0 vote231 views1 answer
Postgres read table structure
SQL
14 votes247 views3 answers
Inner join sql oracle
SQL