On Wed, Mar 19, 2014 at 4:36 PM, Alex Loukissas <a...@maginatics.com> wrote: > On Wed, Mar 19, 2014 at 8:32 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > Thanks everyone for your comments. IIUC, the correct way of going about > what I want to do is to use BINARY collation on the column I'm interested > in and when I want to do unicode-aware case-insensitive lookups, they > should look something like SELECT * FROM table WHERE LOWER(col_name) = > LOWER(key), correct? It seems like with ICU support, LOWER( ) will call > u_foldCase under the covers, which is what I want.
But if you use one collation for the column, and another for the query, don't you implicitly disable indexes via incompatible collations? Is SQLite even aware of the mismatch? --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users