I'm pretty sure that's the bug that has been talked about to death.
It's listed in the bug database on the MySQL website, and there's an
explanation included there. But you've been on this list for a while,
so I'm surprised you didn't notice it. In fact, there was additional
explanation posted on this list about a week or two ago in addition to
the explanation in the bug database.
-----Original Message-----
From: Darren Hill [mailto:dar...@ormac.com]
Sent: Sunday, December 05, 2004 11:20 AM
To: dot...@lists.mysql.com
Subject: #HY000Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='
Sorry if this has been posted, but I looked everywhere.
I recently upgraded the MySQL server to 4.1.7, and changed nothing else
... no I get this error. Can anyone help?