title: MySql Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE)
body: <p>When I ran this query :</p>
  <pre><code>SELECT *
  FROM text_trainer    
  WHERE text LIKE '%@CommonBlackGirI: Tyree from Straight Outta Compton %'
  LIMIT 0 , 30
  </code></pre>
  <p>I faced this error:</p>
  <blockquote>
  <p>MySQL said: Documentation</p>
  <h1>1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation 'like'</h1>
  </blockquote>
  <p>I tried some solution .BUT not working. I want search this  line :</p>
  <p>&quot;@CommonBlackGirI: Tyree from Straight Outta Compton &quot;</p>
  <p>in text column .</p>
  <p>Thanks in advance .</p>