[turba] Strict field checking

[Jon Parise]

On Sun, Jun 03, 2001 at 12:13:41AM -0400, Chuck Hagenbuch wrote:

> > Why?  It makes it a little harder to search for names (using
> > SQL) because the search becomes case-sensitive when strict
> > fields are used.
> 
> That's for the owner field, not the key. It ensures that user
> 'smith' won't be able to access contacts owned by user
> 'smithfield'. It shouldn't affect looking for names at all...

You're right.  Further investigation uncovered the case-sensitive
nature of PostgreSQL's LIKE comparison operator.  They added an
ILIKE operator for case-insensitive comparisons, although that's
not in the SQL standard.

-- 
Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
http://www.csh.rit.edu/~jon/  :  Computer Science House Member