title: Using COLLATE in Android SQLite - Locales is ignored in LIKE statement
body: <p>When creating my SQLite database in Android I set the database locale - db.setLocale(new Locale("cz_CZ")). This is a Czech locale.</p>
  
  <p>A SELECT statement works and takes the locale into account, for example:</p>
  
  <pre><code>SELECT * from table WHERE name='sctzy' COLLATE LOCALIZED 
  </code></pre>
  
  <p>Will find the entry 'ščťžý'.</p>
  
  <p>But using LIKE will fail:</p>
  
  <pre><code>SELECT * from table WHERE name LIKE '%sctzy%' COLLATE LOCALIZED 
  </code></pre>
  
  <p>No row is returned.</p>
  
  <p>BTW. There is no java.text.Normalized class in Android. I thought I could make a second column with a normalized text, stripped of special characters, which would be used for searching - but I am missing a class or way how to normalize the String.</p>