/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 vote196 views1 answer
How to delay stored procedure execution in sql server
SQL
25 votes182 views5 answers
Date in mysql
SQL
3 votes172 views3 answers
Remove all spaces from string sql
SQL
0 vote185 views1 answer
Select year from dual oracle
SQL
0 vote211 views1 answer
Mysql limit order by
SQL
0 vote188 views1 answer
Sql server on mac m1
SQL
0 vote206 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
6 votes174 views1 answer
What is where clause in sql
SQL
0 vote231 views3 answers
Classement rang mysql 7
SQL
7 votes157 views6 answers
Reset identity column in sql server
SQL