First of all I would like to wish you a happy new year.
I use SQLite with OrmLite and try to make case insensitive search with non ascii characters.
I know the SQLite doesn’t support this by default. I try to implement SQLiteFunction but I don’t know where should I register that function (I tried in apphost but not working for me).
Here is a fragment from the generated sql statement.
...upper("Protocol"."ShortName") like @0 LIMIT 100 PARAMS: @0=%ÉP%
The above sql query only filter records where ShortName contains É + p or P (e.g. CsapatÉpítés sablon-1) but doesn’t contains é + p OR P (e.g. Csapatépítés sablon-2)
SQLite functions are unknown and unrelated to OrmLite, your linked post shows how to use “System.Data.SQLite” APIs to register a custom function, once registered it’s presumably able to use your custom function in SQL that SQLite executes.
This operates at the SQL level, there’s nothing you need to register with OrmLite which is oblivious to any function extensions.