Searching with no case sensitivity?

Is there an easy way to turn off case sensitivity for the search feature
in RT 3.8.x? I am using MySql as the database and tried a few
suggestions I found by googling the problem but none of them work.

Peter Boguszewski
Library Systems Administrator
UW Madison - Library Technology Group
pboguszewski@library.wisc.edu
608.262.4768

Is there an easy way to turn off case sensitivity for the search feature in
RT 3.8.x? I am using MySql as the database and tried a few suggestions I
found by googling the problem but none of them work.

I’m pretty sure it’s just a matter of the collation setting for your database.

Cambridge Energy Alliance: Save money. Save the planet.

Good morning,

Is there an easy way to turn off case sensitivity for the search feature in
RT 3.8.x? I am using MySql as the database and tried a few suggestions I
found by googling the problem but none of them work.

I’m pretty sure it’s just a matter of the collation setting for your database.

Would you mind giving me some additional pointers, I’m having the same trouble with a Postgres Database and I am no Postgres Expert.

Best regards,
Torben Nehmer
Torben Nehmer
Diplom Informatiker (FH)
Business System Developer
CANCOM Deutschland GmbH
Messerschmittstr. 20
89343 Scheppach
Germany
Tel.: +49 8225 - 996-1118
Fax: +49 8225 - 996-41118
torben.nehmer@cancom.de
www.cancom.de
CANCOM Deutschland GmbH
Sitz der Gesellschaft: Jettingen-Scheppach
HRB 10653 Memmingen
Geschäftsführer: Paul Holdschik, Christian Linder
Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt!
This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!

Is there an easy way to turn off case sensitivity for the search feature
in RT 3.8.x? I am using MySql as the database

Terrible, awful hack of DBIx::SearchBuilder.pm
(/usr/share/perl5/DBIx/SearchBuilder.pm) to transform the case
sensitive BLOB column to a case-INsensitive during WHERE clause
comparison:

line 991

  • $subclause =~ s/Attachments_[0-9].Content/CONVERT($& Using latin1)/;

If you use SearchBuilder for anything other than RT with MySQL, this
hack will break your stuff. But it will fix the RT searches to be case
insensitive. You will find “tHisORThat” when you search for
"thisorthat"

Terrible, awful hack of DBIx::SearchBuilder.pm
That’s not case-insensitive search, but case-insensitive fulltext: search

This is not necessary for searching subjects.
Cambridge Energy Alliance: Save money. Save the planet.