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 into the mix and that file brought I believe about 80k to final library size. It would be nice if that get incorporated into the tree, of course with defines for those who don't write Unicode data to db. Regards, Miha "Dan" <[EMAIL PROTECTED]> wrote on 07.04.2008 8:18:50: > >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 to read. At least he doesn't call >> it a >> feature. > >The answer you were provided with is correct and canonical in my >opinion. > >The SQLite source archive (.tar.gz, not sure about the preprocessed >versions) contains source code for an sqlite extension that binds >the ICU library to SQLite using the custom collation sequence interface >(and others). With this extension, SQLite uses the upper/lower case >tables that are part of unicode. > >See ext/icu/README in the source distro for details. > >Dan. > > > >> 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 -- It's time to get rid of your current e-mail client ... ... and start using si.Mail. It's small & free. ( http://www.simail.si/ ) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
