title: How to ignore collation in mysql query
body: <p>I have got a field in mysql table with the type SET and collation latin general ci and i am querying like this</p>
  
  <pre><code>SELECT * FROM `tblCountry` WHERE FIND_IN_SET("KAN", `tLang`)
  </code></pre>
  
  <p>, It works fine in sqlyog, but in phpmyadmin it gives me error </p>
  
  <pre><code>#1267 - Illegal mix of collations (utf8_unicode_ci,COERCIBLE) and (latin1_general_ci,IMPLICIT) for operation 'find_in_set'
  </code></pre>
  
  <p>So how to ignore the collation type, is there any work around for this</p>