title: Illegal mix of collations MySQL Error
body: <p>I'm getting this strange error while processing a large number of data...</p>
  
  <pre><code>Error Number: 1267
  
  Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
  
  SELECT COUNT(*) as num from keywords WHERE campaignId='12' AND LCASE(keyword)='hello again æ˜” ã‹ã‚‰ ã‚ã‚‹ å ´æ‰€'
  </code></pre>
  
  <p>What can I do to resolve this? Can I escape the string somehow so this error wouldn't occur, or do I need to change my table encoding somehow, and if so, what should I change it to?</p>