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