title: UTF-8 in MySQL: Both precise string comparison and caseless fulltext search possible?
body: <p>Through research and testing, I have found that it seems that the most equal behavior to a latin charset exists if one uses utf8_bin encoding for fields (guarantees accurate string comparison) and converts the collation to e.g. utf8_general_ci in "order by" clauses.</p>
  
  <p>However, I can't find a workaround to make caseless fulltext search work, since there is neither collation conversion, nor does it seem one can use "lower" on the fulltext key. </p>
  
  <p>Considering what I've read about this whole topic so far, this might be like having your cake and eating it too but I figured I'd ask before I go back to latin charset and drop international support from my website.</p>