title: How to deal with accented characters in iOS SQLite?
body: <p>I need to perform a SELECT queries that are insensitive to case and accents. For demo purposes, I create a table like that:</p>
  
  <pre><code>create table table
  (
    column text collate nocase
  );
  
  insert into table values ('A');
  insert into table values ('a');
  insert into table values ('Á');
  insert into table values ('á');
  
  create index table_cloumn_Index
    on table (column collate nocase);
  </code></pre>
  
  <p>Then, I get those results when executing the following queries:</p>
  
  <pre><code>SELECT * FROM table WHERE column LIKE 'a';
  &gt; A
  &gt; a
  
  SELECT * FROM table WHERE column LIKE 'á';
  &gt; á
  
  SELECT * FROM table WHERE column LIKE 'Á';
  &gt; Á
  </code></pre>
  
  <p>How can I fix that so the results for any of the following queries be like that:</p>
  
  <pre><code>&gt; A
  &gt; a
  &gt; Á
  &gt; á
  </code></pre>
  
  <p>The sqlite is running on iOS, by the way.</p>
  
  <p>Thanks in advance,</p>