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 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 documentation, this is not Unicode-aware, which is why I >> turned to the ICU extension. What should be the equivalent usage where >> sqlite does case folding using ICU? >> > > I don't think there is a way to do that with the current SQLite ICU > extension. > > Dan. > I suppose I can declare the column as BINARY and use LOWER( ) in my select statements. Browsing through the code though, I do see uses of u_foldCase in certain places, which leads me to believe that what I want may be already there. I'll try to unit test this. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Alex Loukissas www.maginatics.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users