Re: [rt-users] Searching with no case sensitivity?
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. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching with no case sensitivity?
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.neh...@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! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] 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 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 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching with no case sensitivity?
On Mon, May 17, 2010 at 15:38, Peter Boguszewski pboguszew...@library.wisc.edu wrote: 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. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
