title: What collation to use in MySQL for case-insensitive UTF8 matches, but where aee is not the same as áéé?
body: <p>I have a bunch of <code>LONGTEXT</code> fields in my database that uses "Table Default" collation.</p>
  
  <p>The table's collation is "utf8 - default collation".</p>
  
  <p>I just started using MySQL so I'm guessing "utf8 - default collation" means the tables gets its value from some global variable, probably defined in my.ini?</p>
  
  <p>How do change this value, using MySQL workbench 6.0? In Options File > General there is a field named "collation-server", am I supposed to write something there?</p>
  
  <p>I want <code>SELECT * FROM table WHERE field='abc'</code>; to NOT find <code>'ábc'</code> but it SHOULD find <code>'ABc'</code>.</p>
  
  <p>I have many, many tables with "utf8 - default collation", if I can't change something in my.ini to change this value is there some other way of changing all of them? Would save me a lot of trouble doing this manually for hundreds of tables (auto-created from a different type of database, that's why I have so many tables even though I just started using MySQL).</p>