[sqlite] Is SQLite Case Sensitive?

[Lee Crain]

I am working on an application where I am importing data for which great
care has NOT been taken to ensure uppercase and lowercase letters have
been entered appropriately.


Would a search for an 'a' return a different result than a search for an
'A'?


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?

Thanks,

Lee Crain



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------