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 "="

D

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

Reply via email to