[rt-users] Query on Content is case sensitive

Lamers, Dan dlamers at elcan.com
Wed Jul 8 16:50:42 EDT 2009


I've recently upgraded to rt3.8.3 from 3.6.5 and everything is working
very well except that I've just discovered that a query based on
"Content" is case sensitive.  I've tried other queries based on
"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 and that type is case sensitive according to mysql
documentation.

Has anyone else noticed this behaviour and are there suggestions for a
workaround?

Thanks,
Dan



More information about the rt-users mailing list