Please try moving your COLLATE clauses into the table definition. e.g. instead of
CREATE UNIQUE INDEX "Disruptions_Idx3" ON Disruptions ("version" COLLATE NOCASE ASC, "Disruption_id" COLLATE NOCASE ASC, "location" COLLATE NOCASE ASC); Your table definition should have "version" integer NOT NULL COLLATE NOCASE, "Disruption_id" INTEGER NOT NULL COLLATE NOCASE, ... "location" integer NOT NULL COLLATE NOCASE, and the index should be CREATE UNIQUE INDEX "Disruptions_Idx3" ON Disruptions ("version" ASC, "Disruption_id" ASC, "location" ASC); Once data has been entered, do ANALYZE. This step may take a long time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users