On Fri, 24 Oct 2014 21:44:50 +0400 dd <durga.d...@gmail.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users