title: Android, Diacritic Insensitive SQLite Search
body: <p>i'm trying to query a SQLite database in android where french characters with accents should be handled like normal latin characters, for example:</p>
  
  <pre><code>SELECT * FROM x WHERE y LIKE %cafe%
  </code></pre>
  
  <p>should return</p>
  
  <pre><code>café, câfè, ...
  </code></pre>
  
  <p>I have googled for a whole day now and read all concerning posts on stackoverflow.
  The possibility to add a column to the table that includes normalized titles is no option, because the database is fetched from a server and maintained by a third party.</p>
  
  <p>Using collations mentioned in other posts like</p>
  
  <pre><code>Latin1_general_CI_AI
  </code></pre>
  
  <p>is also no option, because SQLite only supports 3 (in android 5) collations that don't help me.</p>
  
  <p>Setting the database in android to </p>
  
  <pre><code>Locale.FRENCH
  </code></pre>
  
  <p>and using collation</p>
  
  <pre><code>COLLATE LOCALIZED
  </code></pre>
  
  <p>also doesn't do the trick.</p>
  
  <p>I know there is some flag in iOS (DiacriticInsensitiveSearch) that does it automatically and so my hope is that something like this is available for android too.</p>
  
  <p>Any ideas? Thanks in advance!</p>