title: MySQL searching "äåö" in a UTF-8 table doesnt find anything
body: <p>The data is displayed correctly but when doing searches it doesn't find anything. This is how data is stored in a table with UTF8 encoding. </p>
  
  <pre><code>Default charset: utf8mb4
  names: utf8
  character_set_client : utf8
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/OjAVB.png" alt="enter image description here"></p>
  
  <pre><code>SELECT * FROM article WHERE description like '%några%' //returns null but it should return one row
  SELECT * FROM article WHERE description like '%nå%' //works
  SELECT * FROM article WHERE description like '%någ%' //returns null
  </code></pre>
  
  <p>I think mysql converts å to a. </p>
  
  <p>I have tried to convert the search query to utf8 using php function utf8_encode($str). But no success here.
  How can I solve this issue? </p>