[rt-devel] Case insensitive search.
jesse at fsck.com
Mon Jun 4 12:57:39 EDT 2001
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
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
> where lower(subject) like lower('%value%');
> 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
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
More information about the Rt-devel