Illegal collation... bug?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Illegal collation... bug?

Post by Steveo31 »

The Error:

#1266 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

The query:

SELECT users.username, users.email, users.password
FROM users, userprefs
WHERE users.username = 'myusername'
AND users.password = 'passsy'
AND users.valid =1
LIMIT 0 , 30

The Bug page:

http://bugs.mysql.com/bug.php?id=4295


The whole "cast" thing works, but is a pain in the neck. Any ideas?
Post Reply