On 31 Mar 2010, at 12:51am, Rashed Iqbal wrote: > Is there a way to make SQLite queries case-insensitive? > > For example my query is: > > SELECT * from Customers WHERE LastName = 'Shaw' AND FirstName = 'Gioia' > > and I want to be able to get same results no matter if the case is good > in the DB or not or in the query.
You need a change from the standard collating system. Take a look at section 6.2 of http://www.sqlite.org/datatype3.html I haven't tried this myself but I think that if you define a column as columnName TEXT COLLATE NOCASE then all sorting and SELECT queries on it will ignore case. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
