I have a virtual table implementation that implements the xBestIndex/xFilter functions. Problem: A LIKE query (for eg. field LIKE "prefix%") gets sets to xBestIndex as a GT/LT pair. However, I can't tell from the sqlite3_index_info whether that GT/LT should be NOCASE collation or BINARY collation. I want the default LIKE behaviour, which is NOCASE, but I can't figure out where to glean this information from inside xBestIndex.
Am I missing something? Thanks, Ben _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users