I need to manually build System.Data.SQLite (which is an ADO.NET adapter for SQLite) and I need to include ICU extension for sqlite because I have need for case insensitive searches.
I have sqlite-netFx-source-1.0.84.0 source, current source can be downloaded from link.
How can I do this? I didnt find any answer yet, the most closely was answer on this question, but I need icu for System.Data.SQLite and I need to be able to manually build everything.
Also, if this what I need is possible, will I be able to execute case insensitive WHERE field LIKE
queries in SQL for existing, non FTS tables? Or ICU extension just work for FTS tables?
Thanks in advance