/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

1 vote112 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote115 views2 answers
Transaction php
SQL
0 vote125 views1 answer
Char vs varchar2 in sql
SQL
2 votes118 views4 answers
Check timezone of mysql database
SQL
0 vote119 views1 answer
Mysql drop vs delete
SQL
1 vote127 views3 answers
Divide by zero error in sql
SQL
1 vote108 views1 answer
Mysql current time
SQL
16 votes105 views2 answers
Gremove folder from git
SQL
0 vote126 views1 answer
Tsql delete all rows
SQL
0 vote151 views1 answer
Postgresql alter table sequence
SQL