/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 vote412 views1 answer
SQL joins in python
SQL
0 vote372 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote405 views1 answer
Java sql timestamp now
SQL
28 votes374 views6 answers
Mysql change user password
SQL
0 vote320 views1 answer
Get only first row mysql
SQL
5 votes391 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote379 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote350 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote436 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote343 views1 answer
Plpgsql if statement
SQL