Illegal collation... bug?
Posted: Fri Dec 24, 2004 3:35 am
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?
#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?