On Fri, 24 Oct 2014 21:44:50 +0400
dd <[email protected]> wrote:
> >>Convert everything to upper (or lower) case brute force.
> Sorry. I am not clear. Can you please elaborate this.
The standard function tolower(3) is locale-dependent. If your locale is
set to match the data's single-byte encoding,
tolower('Ö') == tolower('ö') .
If you are using Unicode, you have towlower(3) as defined by C99. If
you're using utf-8, you'll want to call ivonv(3) first to convert the
string to an array of wint_t.
Plug that into the xCompare function of a custom collation, and you
have your own case-insensitive matching capability.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
