Hi, I have attached a one-liner (vtab-collation.patch) that sends collation information through to virtual tables. The bigger patch (vtab-collation-full.patch) illustrates the header file changes necessary to make this compile.
Unfortunately, it's not as simple as just one line of code, since my patch requires exposure of CollSeq to the outside world. What this patch does is to grant the virtual table the opportunity to distinguish between the following two queries: SELECT * FROM vtab WHERE field = 'abc'; SELECT * FROM vtab WHERE field = 'abc' COLLATE NOCASE; This also grants the virtual table the ability to recognized case-insensitive LIKE queries, which is also not currently possible. I basically just copied the single line from bestBtreeIndex into bestVirtualIndex. Is there any chance something like this could get merged into the main line? Regards, Ben
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users