/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 vote334 views1 answer
Mysql search multiple tables
SQL
4 votes327 views1 answer
Create column mysql terminal
SQL
0 vote353 views1 answer
Laravel migration sql dump
SQL
24 votes333 views5 answers
Sql server insert into select
SQL
0 vote325 views1 answer
Mariadb used space
SQL
3 votes341 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote326 views1 answer
Select from 3 tables one is empty
SQL
0 vote322 views1 answer
Database springboot
SQL
0 vote406 views1 answer
Selecting specific day in colum sql
SQL
1 vote324 views1 answer
User privileges postgresql information_schema
SQL