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

??


--------
2011 Training: http://bestpractical.com/services/training.html

Reply via email to