/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 vote192 views1 answer
Java spring boot connect to sql server
SQL
0 vote211 views1 answer
Write a query to peint the pattern P(20)
SQL
1 vote193 views1 answer
Ilike for date postgres
SQL
0 vote198 views1 answer
Android sqlite add column if not exists
SQL
1 vote196 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
7 votes219 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote209 views1 answer
Alter check command
SQL
0 vote196 views2 answers
Return the number of records in a single table mysql
SQL
0 vote196 views1 answer
Database xml sql
SQL
2 votes207 views1 answer
Sql server find columns list in tables
SQL