SQLite have big problem about non-ascii character
(1) By suat suphi (suphisuphi) on 2022-09-16 19:54:31 [source]
Hi, this is a big problem. You cant use this database. You cant use it like this: customerData = customerData.Where(i => i.Title.ToLower().Contains(searchValue.ToLower())
if you don't use English. is it just for English Database ?
Why don’t have support non-ascii character ?
lower(X) The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.
(2) By Stephan Beal (stephan) on 2022-09-16 20:24:14 in reply to 1 [link] [source]
Why don’t have support non-ascii character?
It does, and the snippet you quoted from the documentation tells you had to get that support:
lower(X) The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.