Dixon Hutchinson <[EMAIL PROTECTED]> wrote: > I have an SQLite db with one TEXT column. That column and an INTEGER > column (not the rowid as this column is definitely not unique by itself) > are declared UNIQUE together. > > CREATE TABLE foo ( > bar TEXT, > p INTEGER, > rowid INTEGER PRIMARY KEY AUTOINCREMENT, -- I know... this is > implicit... > UNIQUE(p, bar) > ); > > All of my searches of the db when searching by the TEXT column must be > case insensitive. So I have been using: SELECT * FROM foo WHERE bar > LIKE 'some text here'; > > Is that better, worse, or no different than using a "COLLATE NOCASE" > qualifier on the TEXT column and changing the "LIKE" to "=" >
Using COLLATE NOCASE will be faster. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
