[rt-users] case insensitive searching in Content?

Václav Ovsík vaclav.ovsik at i.cz
Tue Jun 8 03:10:23 EDT 2010


... 3rd try to mail ...

On Sun, Jun 06, 2010 at 02:34:58PM -0500, Kenneth Marshall wrote:
> Hi Zito,
> 
> You can look in the mailing list archives for several similar "discoveries" on
> how MySQL works with content searches and the longblob data type. I would
> definitely recommend using PostgreSQL for its full-text indexing available
> in the wiki. Of course, I am partial... :)

Hi Ken,
thanks for the suggestion. I red the wiki page
http://wiki.bestpractical.com/view/PostgreSQLFullText already.
I'm definitely going to try this way, also patching DBIx::SearchBuilder
is a bit hack, but ILIKE is too slow on Pg.
Regards
-- 
Zito



More information about the rt-users mailing list