[rt-devel] Case insensitive search.

[Jesse]

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
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

...realized that the entire structure of the net could be changed to be made 
more efficient, elegant, and spontaneously make more money for everyone 
involved. It's a marvelously simple diagram, but this form doesn't have a way 
for me to draw it.  It'll wait. 				-Adam Hirsch