[rt-users] Case sensitive searching?

[Kevin Falcone]

On Fri, Jul 29, 2011 at 09:30:59AM -0700, Yan Seiner wrote:
> I just found some strange behavior in the Ticket Search.
> 
> When I try to search on content, it appears to be case sensitive.
> 
> Per the MySQL docs, the LIKE operator is case inseinsitive:
> 
> http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html

Check the type of the Content field, that will probably explain part
of it.  Also check your collation.  Be careful changing your
collation, and please don't change the type of the Content field.

If you're on RT4 you should really be setting up and using the sphinx
integration if you can, since Content like 'foo' is *really* slow.

-kevin

> Howner, if I search using
> 
> Content LIKE 'phase'
> 
> I get a different result than if I search for
> 
> Content LIKE 'Phase'
> 
> In the former, I get only tickets with the word "phase" in all lower case;
> in the latter I get only tickets with the word "Phase" with capitalized
> leading "P".
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110729/abba1b4a/attachment.sig>