/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 vote174 views1 answer
Get the next column of a table in mysql
SQL
0 vote166 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote229 views1 answer
TSQL Find csv file in folder
SQL
0 vote172 views1 answer
Mysql set variable to today's date
SQL
0 vote194 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote190 views1 answer
The fetch keyword oracle
SQL
3 votes155 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote176 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote184 views1 answer
Add sqlcmd to path linux
SQL
0 vote180 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL