MySQL-Illegal mix of collations(utf8_general_ci,COERCIBLE) and(latin1_swedish_ci,IMPLICIT) for operation 'UNION'

How do I fix that error once and for all? I just want to be able to do unions in MySQL.(I'm looking for a shortcut, like an option to make MySQL ignore that issue or take it's best guess, not loo…


mysql What's the difference between utf8_general_ci and utf8_unicode_ci

Between utf8_general_ci and utf8_unicode_ci, are there any differences in terms of performance?…


MySQL Illegal mix of collations(utf8_unicode_ci,IMPLICIT) and(utf8_general_ci,IMPLICIT) for operation '='

I need your help in identifying why this error is coming Illegal mix of collations(utf8_unicode_ci,IMPLICIT) and(utf8_general_ci,IMPLICIT) for operation '=' The procedure was working fine till yeste…


Illegal mix of collations MySQL Error

I'm getting this strange error while processing a large number of data... Error Number: 1267 Illegal mix of collations(latin1_swedish_ci,IMPLICIT) and(utf8_general_ci,COERCIBLE) for operation '='…



mysql What are the diffrences between utf8_general_ci and utf8_unicode_ci?

Possible Duplicate: What's the difference between utf8_general_ci and utf8_unicode_ci I've got two options for unicode that look promising for a mysql database. utf8_general_ci unicode(multilingua…


Illegal mix of collations error in MySql

Just got this answer from a previous question and it works a treat! SELECT username,(SUM(rating)/COUNT(*)) as TheAverage, Count(*) as TheCount FROM ratings WHERE month='Aug' GROUP BY username HAVING…


Creating mysql table with explicit default character set, what if I don't?

In mysql 5.x Whats the difference if I do something like this: CREATE TABLE aTable(id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, aNumber bigint(20) DEFAULT NU…


mysql How to change all the tables in my database to UTF8 character set?

My database is not in UTF8, and I'd like to convert all the tables to UTF8, how can I do this?…


MySQL treats ÅÄÖ as AAO?

These two querys gives me the exact same result: select*from topics where name='Harligt'; select*from topics where name='Härligt'; How is this possible? Seems like mysql translates åäö to aao whe…


Troubleshooting “Illegal mix of collations” error in mysql

Am getting the below error when trying to do a select through a stored procedure in MySQL. Illegal mix of collations(latin1_general_cs,IMPLICIT) and(latin1_general_ci,IMPLICIT) for operation '=' A…




mysql collation utf8 utf8_unicode_ci set character for collations operation mix