[rt-devel] Case insensitive search.

[Jason Slagle]

The superior RDBMS of course, Postgresql :D

I think case sensitivity is the "right thing".

I can just hack the local copy to use ILIKE then until 2.0 hits the
shelves.

Jason

-- 
Jason Slagle - CCNP - CCDP
Network Administrator - Toledo Internet Access - Toledo Ohio
- raistlin at tacorp.net - jslagle at toledolink.com - WHOIS JS10172
/"\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
\ /   ASCII Ribbon Campaign  . If dreams are like movies then memories
 X  - NO HTML/RTF in e-mail  .   are films about ghosts..
/ \ - NO Word docs in e-mail .     - Adam Duritz - Counting Crows


On Mon, 4 Jun 2001, Jesse wrote:

> What database are you having issues with?  With MySQL, 
> searches are already case insensitive.
> 
> With postgres, the right thing to do, I believe, would be to use ILIKE.
> 
> That particular change is going to have to wait until after 2.0,
> when DBIx::SearchBuilder.pm gets refactored to allow better per-driver
> SQL customization.
> 
> 
> On Mon, Jun 04, 2001 at 10:47:55AM -0400, Jason Slagle wrote:
> > 
> > Would be a big plus on some of the searches (Esp subject and content).
> > 
> > lower() is a SQL92 function I believe so you could make the SQL server do
> > it.
> > 
> > where lower(subject) like lower('%value%');
> > 
> > Jason
> > 
> > -- 
> > Jason Slagle - CCNP - CCDP
> > Network Administrator - Toledo Internet Access - Toledo Ohio
> > - raistlin at tacorp.net - jslagle at toledolink.com - WHOIS JS10172
> > /"\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
> > \ /   ASCII Ribbon Campaign  . If dreams are like movies then memories
> >  X  - NO HTML/RTF in e-mail  .   are films about ghosts..
> > / \ - NO Word docs in e-mail .     - Adam Duritz - Counting Crows
> > 
> > 
> > 
> > _______________________________________________
> > Rt-devel mailing list
> > Rt-devel at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-devel
> > 
> 
>