/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

4 votes323 views1 answer
Sql delete multiple conditions
SQL
0 vote331 views1 answer
Drop view in mysql
SQL
1 vote294 views1 answer
Check if mysql is installed
SQL
0 vote333 views1 answer
Create-table-with-index-organization
SQL
103 votes493 views2 answers
Sql server LIKE '%%'
SQL
15 votes286 views3 answers
Create table with primary key auto increment in sql
SQL
1 vote291 views1 answer
Postgres select as csv
SQL
0 vote286 views1 answer
Dnsmasq.conf location macos
SQL
3 votes300 views2 answers
How to load files in mysql
SQL
0 vote306 views1 answer
Postgresql delete limit
SQL