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? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users