title: How to convert all tables in database to one collation?
body: <p>I'm getting error:</p>
  
  <blockquote>
    <p>Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='"</p>
  </blockquote>
  
  <p>I tried changing both tables manually to <code>utf8_general_ci,IMPLICIT</code> but I'm still getting the error.</p>
  
  <p>Is there a way to convert all tables to <code>utf8_general_ci,IMPLICIT</code> and be done with it?</p>