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
where lower(subject) like lower(’%value%’);
Jason Slagle - CCNP - CCDP
Network Administrator - Toledo Internet Access - Toledo Ohio
email@example.com - firstname.lastname@example.org - 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
jesse reed vincent – email@example.com – firstname.lastname@example.org
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