That was not was I was talking about. I was not talking about Sort Order but about Searches. Keith
On Sat, Apr 5, 2008 at 11:42 PM, Cory Nelson <[EMAIL PROTECTED]> wrote: > Sort order is highly dependent on locale. You can add custom > collations to do this. > > On Sat, Apr 5, 2008 at 10:41 AM, Keith Stemmer > <[EMAIL PROTECTED]> wrote: > > Hello! > > > > I found SQLite quite amazing, but I think there is one showstopper for > me. > > It seems that searches for Unicode strings are case sensitive and there > is > > no (easy) way around that. > > Could you please confirm or deny this? > > > > Your explanation... > > > > (A bug: SQLite only understands upper/lower case for 7-bit Latin > characters. > > Hence the LIKE operator is case sensitive for 8-bit iso8859 characters > or > > UTF-8 characters. For example, the expression 'a' LIKE 'A' is TRUE but > 'æ' > > LIKE 'Æ' is FALSE.). > > > > seems to destroy all my hopes. > > > > Thank you very much! > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > Cory Nelson > http://www.int64.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
