On 2/12/16, Michele Pradella <michele.pradella at selea.com> wrote: > I try using COLLATE NOCASE index with PRAGMA case_sensitive_like=OFF; > and COLLATE BINARY index with PRAGMA case_sensitive_like=ON; > but I have always the query with field LIKE 'AA%' that can't use index > on field "No Query solution" is reported by shell if you try to force > index. And with explain query plan the index on field is not used. > Do you think I'm doing something wrong? >
Yes I do. Please post your schema and your query and we will have a look. -- D. Richard Hipp drh at sqlite.org