title: Mysql SELECT unicode characters
body: <p>I have two tables:</p>
  
  <p><code>words</code> table:</p>
  
  <pre><code>+----+-------+------+
  | id | word  | lang |
  +----+-------+------+
  |  1 | uña   | es   |
  |  2 | two   | en   |
  |  3 | three | en   |
  |  4 | four  | en   |
  +----+-------+------+
  </code></pre>
  
  <p><code>stop_words</code> table:</p>
  
  <pre><code>+----+------+------+
  | id | word | lang |
  +----+------+------+
  |  1 | una  | es   |
  |  2 | one  | en   |
  +----+------+------+
  </code></pre>
  
  <p>I need to select a word from <code>words</code> table where the word are not in <code>stop_words</code> table</p>
  
  <ul>
  <li><p>If I try the below query the result is empty because <code>uña</code> from
  <code>words</code> match with <code>una</code> from <code>stop_words</code></p>
  
  <pre><code>SELECT  *
  FROM words a WHERE word LIKE  'uñ%' AND lang = 'es'
  AND NOT EXISTS( Select *
      FROM stop_words as b WHERE a.word = b.word AND lang = 'es'
  </code></pre>
  
  <p>)</p></li>
  <li><p>If I try to use <code>BINARY</code> the result seem to be OK <strong>but fail</strong> if not use same case (ex: <code>Uñ</code> instead <code>uñ</code> )</p>
  
  <pre><code>SELECT  *
  FROM words a WHERE word LIKE BINARY 'Uñ%'  AND lang = 'es'
  AND NOT EXISTS( Select *
      FROM stop_words as b WHERE BINARY a.word = BINARY b.word AND lang = 'es'
  )
  </code></pre></li>
  </ul>
  
  <p>I use <code>utf8mb4_unicode_ci</code> for database, tables and columns.</p>
  
  <p>Any idea how to solve this?</p>