Re: [sqlite] Unicode searches

2008-04-07 Thread Jay A. Kreibich
> > 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. > <[EMAIL PROTECTED]> wrote: > > That was not was I was talking about. I was not talking about Sort Order but > > about

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-07 Thread Miha Vrhovnik
Someone sent a sqlite3_unicode.c file to this mailing list in the last week of December, 1st week of January which implemented upper/lower and some other functions. File was released as public domain if I remember correctly and used data from Unicode 5.1 standard. As ICU brings a lot of bulk

Re: [sqlite] Unicode searches

2008-04-07 Thread Dan
On Apr 6, 2008, at 5:10 AM, Keith Stemmer wrote: > 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

Re: [sqlite] Unicode searches

2008-04-05 Thread Gunnar Roth
Keith Stemmer schrieb: > Yes, I can add a custom collation which works for ASCII chars LOL. > Plain wrong > If you don't understand the problem, just don't reply. > > Plain unreasonable carefulle read ( and understand) this http://sqlite.org/c3ref/create_collation.html and this

Re: [sqlite] Unicode searches

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

Re: [sqlite] Unicode searches

2008-04-05 Thread Cory Nelson
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

Re: [sqlite] Unicode searches

2008-04-05 Thread Cory Nelson
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

[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