/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 vote134 views1 answer
How to delete a record from sqlite in android
SQL
0 vote146 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote143 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote129 views1 answer
Importance of comment in mysql
SQL
1 vote149 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote127 views1 answer
Clone table structure mysql
SQL
5 votes211 views1 answer
Oracle source query
SQL
0 vote132 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote176 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote169 views1 answer
Postgres select as csv
SQL