title: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)
body: <p>Here is my query:</p>
  
  <pre><code>INSERT INTO location_province(name, country)   
  SELECT child.name
        ,location_country.id
    FROM location_1 child
   INNER JOIN location_1 parent
      ON child.parent_id = parent.id
   INNER JOIN location_country
      ON location_country.name = parent.name
   WHERE child.location_type = 1
  </code></pre>
  
  <p>It throws this error:</p>
  
  <blockquote>
    <p>#1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='</p>
  </blockquote>
  
  <p>What's wrong and how can I fix it?</p>
  
  <hr>
  
  <p><strong>Note:</strong> Adding <code>COLLATE utf8_unicode_ci</code> in the end of query doesn't work either.</p>