Lee Crain <[EMAIL PROTECTED]> wrote:
Would a search for an 'a' return a different result than a search for
an 'A'?
By default, yes.
SELECT * FROM table WHERE field1 = 'a';
Vs.
SELECT * FROM table WHERE field1 = 'A';
If SQLite is case sensitive, is there an easy override for this to
enforce
all lowercase letters?
select * from tableName where field1 = 'a' collate NOCASE;
-- or
select * from tableName where lower(field1) = 'a';
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
