On Sat, Oct 25, 2014 at 7:09 AM, dd <durga.d...@gmail.com> wrote: > Hi, > > icu enabled for sqlite. I didn't do any custom collations/like operator. > > CREATE TABLE test(id integer primary key autoincrement, t text collate > nocase, unique(t)); > > Case 1: When I try to insert 'd' and 'D', throwing constraint violation. > (SUCCESS) > Case 2: When I try to insert 'ö' and 'Ö', sqlite inserted both > sucessfully. (FAILED) > > I expect case 2 should throw constraint violation, but not. Am I missing > anything here? > > > Please read https://www.sqlite.org/src/artifact/d9fbbad0c2f and especially the part about ICU collating sequences. "NOCASE" is still the standard ASCII-only collating sequence, even if you enable ICU.
-- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users