[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turba
Subject:    Re: [turba] Strict field checking
From:       Jon Parise <jon () csh ! rit ! edu>
Date:       2001-06-03 4:35:56
[Download RAW message or body]

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

-- 
Turba mailing list: http://horde.org/turba/
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe@lists.horde.org

[prev in list] [next in list] [prev in thread] [next in thread]