Quote from SQlite.org:
A bug: SQLite only
understands upper/lower case for ASCII characters by default. The
LIKE operator is case sensitive by default for unicode characters that are
beyond the ASCII range.
Same thing happens with SQlite .NET provider though it doesn't use Native SQlite dll. As i understand this bug reproduced in .NET provider for some capability reasons. But what should i do with it when i need case insensitiv unicode like search. I can't lowercase data in DB and use String.ToLower() for like query.
Ii need data in DB with case, and do case insensetive LIKE query....
P.S. Thank you for nice SQLite .NET provider, i have succesfully used it in 2 projects. Pitty that now i had to switch to SQL Server Compact cause of case sensitive LIKE operator, and some performance problems with unicode TEXT fields indexes...