Re: [sqlite] Using ICU case folding support

On Wed, Mar 19, 2014 at 8:36 AM, Alex Loukissas <a...@maginatics.com> wrote: > On Wed, Mar 19, 2014 at 8:32 AM, Dan Kennedy <danielk1...@gmail.com>wrote: > >> On 03/19/2014 09:44 PM, Aleksey Tulinov wrote: >> >>> >>> I've created test database:

Re: [sqlite] Using ICU case folding support

gt; > > Dan. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > Thanks everyone for your comments. IIUC, the correct way o

Re: [sqlite] Using ICU case folding support

On Tue, Mar 18, 2014 at 12:39 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/19/2014 01:22 AM, Alex Loukissas wrote: > >> Hello, >> >> I'm trying to use the ICU extension and it looks like what I want to do is >> not very clear from the documenta

[sqlite] Using ICU case folding support

Hello, I'm trying to use the ICU extension and it looks like what I want to do is not very clear from the documentation. I would like to switch from my current usage, where my column declaration is as follows: CREATE TABLE demo("name text not null COLLATE NOCASE"); As noted in the

[sqlite] failure to build static library with -DSQLITE_ENABLE_ICU

2014-03-14 0:30 GMT+01:00 Alex Loukissas : > I have verified that adding the said include fixes the issue (1-line patch): > > diff --git sqlite3.c sqlite3.c > index 7c6d3e2..a9399e4 100644 > --- sqlite3.c > +++ sqlite3.c > @@ -145656,6 +145656,7 @@ SQLITE_API int sqlite3_rt

[sqlite] failure to build static library with -DSQLITE_ENABLE_ICU

7c6d3e2..a9399e4 100644 --- sqlite3.c +++ sqlite3.c @@ -145656,6 +145656,7 @@ SQLITE_API int sqlite3_rtree_init( #include #include #include +#include /* #include */ Hope this helps others that run into this issue. -- Alex Loukissas www.maginatics.com