SQLite has limitation on using LIKE for non-ASCII symbols. ICU extension solves this problem. How to write code in C# for creating following case insensitive statement:
SELECT * FROM Persons WHERE surname LIKE '%Пупкин%'
P.S. If there is another solution for using in C# LIKE statement for non-ASCII symbols please provide it.
var result = people.Where(x=> x.Surname.IndexOf(searchText, StringComparison.InvariantCultureIgnoreCase) > -1);