[rt-users] Case sensitive searching?

Yan Seiner yan at seiner.com
Fri Jul 29 12:30:59 EDT 2011


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

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".

??




More information about the rt-users mailing list