Re: [sqlite] ICU extension not working as expected

2012-05-23 Thread Jean-Christophe Deschamps
I've downloaded and compiled icu.c according to the instructions in the included README (though I had to add -fPIC to the compiler options). Now, when searching a table, I'm not getting the kind of diacritic-insensitive behavior I was expecting: sqlite> .load lib/libSQLiteICU.so sqlite> sel

Re: [sqlite] ICU extension not working as expected

2012-05-23 Thread Courtney Grimland
> > As you can see, this can get arbitrarily complex. We still don't > have a good answer. Your input is welcomed. > If only I knew enough about the subject to be able to provide any useful input. Naturally, I think it should work exactly as I want it to work at any given moment. ;) > > I

Re: [sqlite] ICU extension not working as expected

2012-05-23 Thread Richard Hipp
On Wed, May 23, 2012 at 2:11 PM, Courtney Grimland < cgriml...@cfa.harvard.edu> wrote: > I've downloaded and compiled icu.c according to the instructions in the > included README (though I had to add -fPIC to the compiler options). > > Now, when searching a table, I'm not getting the kind of > dia

Re: [sqlite] ICU extension not working as expected

2012-05-23 Thread Pavel Ivanov
> I expected both statements to return the same result.  Am I overlooking > something or do I misunderstand the capabilities of ICU's "unicode-aware > LIKE operator"? I believe "unicode-aware LIKE operator" means case-insensitive for non-ASCII characters, not diacritic-insensitive. Pavel On We

[sqlite] ICU extension not working as expected

2012-05-23 Thread Courtney Grimland
I've downloaded and compiled icu.c according to the instructions in the included README (though I had to add -fPIC to the compiler options). Now, when searching a table, I'm not getting the kind of diacritic-insensitive behavior I was expecting: sqlite> .load lib/libSQLiteICU.so sqlite> sele