title: Troubleshooting "Illegal mix of collations" error in mysql
body: <p>Am getting the below error when trying to do a select through a stored procedure in MySQL.</p>
  
  <blockquote>
    <p>Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='</p>
  </blockquote>
  
  <p>Any idea on what might be going wrong here?</p>
  
  <p>The collation of the table is <code>latin1_general_ci</code> and that of the column in the where clause is <code>latin1_general_cs</code>.</p>