title: searching arabic words that have diacritics in mysql
body: <p>to make my question simple anyone knows why this query returns true</p>
  
  <pre><code>SELECT 'الجنة' ='الْجِنَّةِ' COLLATE utf8_unicode_ci ;
  </code></pre>
  
  <p>while this query returns false</p>
  
  <pre><code>SELECT 'الجنة' LIKE '%الْجِنَّةِ%' COLLATE utf8_unicode_ci ;
  </code></pre>
  
  <p>and how could I let the later returns true ? thanks .</p>