[rt-users] Case sensitive searching?

Ruslan Zakirov ruz at bestpractical.com
Fri Jul 29 16:25:33 EDT 2011


On Fri, Jul 29, 2011 at 11:23 PM, Kevin Falcone
<falcone at bestpractical.com> wrote:
> 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.

In RT3.8 Content is a BLOB column and it's how it should be. So search
is binary and case sensitive.

> 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".
>
>
> --------
> 2011 Training: http://bestpractical.com/services/training.html
>



-- 
Best regards, Ruslan.



More information about the rt-users mailing list