C# Entity - SQLite and Unicode (Greek ) -

var q_truck = (from item in datagate.item                join belong in datagate.belong on item.belong_id equals belong.id                item.plate.startswith(textbox1.text) 

so problem here when use greek letters .startswith or .contains doesn't work, fetching wrong results.

connectionstring has "charset=utf8" in line, string fields nvarchar, model properties of string fields have true in unicode, on modelcontext added

modelbuilder.properties<string>().configure(x => x.hascolumntype("nvarchar")) 

, erased database made new, made string fields, text/string/varchar ... nothing. english , numbers work fine.

i have added necessary nuget packages, microsoft.data.sqlite. don't know else do, i'm trying make work 3 days now, no result!

sqlite faq:

case-insensitive matching of unicode characters not work.

the default configuration of sqlite supports case-insensitive comparisons of ascii characters.

you need sqlite icu (international components unicode) extension.