How to solve - Illegal mix of collations in mysql?

Posted by rocksolid on Stack Overflow See other posts from Stack Overflow or by rocksolid
Published on 2010-06-12T16:23:43Z Indexed on 2010/06/12 16:42 UTC
Read the original article Hit count: 234

Filed under:
|
|

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 '='

Any idea on what might be going wrong here?

The collation of the table is latin1_general_ci and that of the column in the where clause is latin1_general_cs

Thanks!

© Stack Overflow or respective owner

Related posts about mysql

Related posts about collation