[rt-users] Query Builder is case sensitive when using the content field

Ruslan Zakirov ruslan.zakirov at gmail.com
Tue Jul 14 08:25:30 EDT 2009


It's side effect of conversion to blob instead of text. Content can
not be of text type cuz it can contain binary data. May be we can come
up with some patch that workaround this for full text searches, but
I'm afraid that will make searches even slower.

On Tue, Jul 14, 2009 at 4:02 PM, Lamers, Dan<dlamers at elcan.com> wrote:
> I've noticed that using the query builder with the "Content" field is
> case sensitive.  I've tried other queries based on fields such as
> "Subject" and "Requestor" etc and they are all case INsensitive.
> Looking at the mysql upgrade script, I think that Content has been
> changed to longblob in RT 3.8.3 and that type is case sensitive
> according to mysql documentation.  Everything I've found on the wiki
> seems to imply that queries should all be case INsensitive.
> Has anyone else noticed this behaviour and are there suggestions for a
> workaround?
> Thanks,
> Dan

Best regards, Ruslan.

More information about the rt-users mailing list