Re: [sqlite] Unicode searches

2008-04-07 Thread Keith Stemmer
Cory, sorry, I had a bad day. Keith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unicode searches

2008-04-05 Thread Keith Stemmer
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 Ste

Re: [sqlite] Unicode searches

2008-04-05 Thread Keith Stemmer
, 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 (ea

[sqlite] Unicode searches

2008-04-05 Thread Keith Stemmer
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