Yes, I can add a custom collation which works for ASCII chars LOL. If you don't understand the problem, just don't reply.
By the way, you can read on the SQLite website that the developer describes my problem as a BUG which is nice to read. At least he doesn't call it a feature. Keith. > > Sort order is highly dependent on locale. You can add custom > > collations to do this. On Sat, Apr 5, 2008 at 11:58 PM, Cory Nelson <[EMAIL PROTECTED]> wrote: > They are one and the same. Look up collations. > > On Sat, Apr 5, 2008 at 2:55 PM, Keith Stemmer > <[EMAIL PROTECTED]> wrote: > > 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! > > -- > 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
