title: How to ignore accent in SQLite query (Android)
body: <p>I am new in Android and I'm working on a query in SQLite. 
  My problem is that when I use accent in strings e.g.</p>
  
  <ul>
  <li>ÁÁÁ</li>
  <li>ááá</li>
  <li>ÀÀÀ</li>
  <li>ààà</li>
  <li>aaa</li>
  <li>AAA</li>
  </ul>
  
  <p>If I do:</p>
  
  <pre><code>SELECT * FROM TB_MOVIE WHERE MOVIE_NAME LIKE '%a%' ORDER BY MOVIE_NAME;
  </code></pre>
  
  <p>It's return:</p>
  
  <ul>
  <li>AAA</li>
  <li>aaa (It's ignoring the others)</li>
  </ul>
  
  <p>But if I do:</p>
  
  <pre><code>SELECT * FROM TB_MOVIE WHERE MOVIE_NAME LIKE '%à%' ORDER BY MOVIE_NAME;
  </code></pre>
  
  <p>It's return:</p>
  
  <ul>
  <li>ààà (ignoring the title "ÀÀÀ")</li>
  </ul>
  
  <p>I want to select strings in a SQLite DB without caring for the accents and the case. Please help.</p>