Case insensitive search


#1

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@tacorp.net - jslagle@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

#2

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@tacorp.net - jslagle@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.orgjesse@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


#3

The superior RDBMS of course, Postgresql :smiley:

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@tacorp.net - jslagle@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 CrowsOn 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@tacorp.net - jslagle@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel