Re: [sqlite] Re: Is SQLite Case Sensitive?

On 08/08/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > 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

[sqlite] Re: Is SQLite Case Sensitive?

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