title: How to write C# case insensitive LIKE statement for SQLIte using ICU extension?
body: <p>SQLite has <a href="http://www.sqlite.org/faq.html#q18" rel="nofollow noreferrer">limitation</a> on using LIKE for non-ASCII symbols. ICU extension <a href="http://www.sqlite.org/src/doc/trunk/ext/icu/README.txt" rel="nofollow noreferrer">solves</a> this problem.
  How to write code in C# for creating following case insensitive statement:</p>
  
  <pre><code>SELECT * FROM Persons WHERE surname LIKE '%Пупкин%'
  </code></pre>
  
  <p>P.S. If there is another solution for using in C# LIKE statement for non-ASCII symbols please provide it.</p>