/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 vote305 views1 answer
Oracle job class
SQL
0 vote306 views1 answer
Call rest api from postgresql
SQL
0 vote296 views1 answer
Uuid sqlalcomany
SQL
0 vote322 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote290 views1 answer
Mysql show foreign keys column
SQL
0 vote325 views1 answer
Count columns psql(PostreSQL)
SQL
10 votes284 views2 answers
Mysql select timestamp group by day
SQL
31 votes322 views4 answers
Mysql grant execute
SQL
11 votes334 views3 answers
Python sqlite3 create table if not exists
SQL
1 vote246 views1 answer
Ms sql - add one hour to time
SQL