I have a virtual table, but I cannot figure out how to discover the collating sequence of a query expression passed to xBestIndex.
As far as I can tell, these three statements ... SELECT * FROM tab WHERE col = 'val'; SELECT * FROM tab WHERE col = 'val' COLLATE BINARY; SELECT * FROM tab WHERE col = 'val' COLLATE NOCASE; ... send identical data to xBestIndex. Am I right if I conclude that the xBestIndex interface would need to be extended in order to make it possible to distinguish between these three different queries? Thanks, Ben _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
