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