Does RT support MySQL's full-text search?


#1

Hi all,

I was wondering if RT supports MySQL’s full text search feature [1].
As we are still using 3.4, I can not check this, myself.

Thanks for any hints/links,
Richard

[1] http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html


#2

MySQL’s full text search is not supported with the INNODB tables
that are required for RT. It is not available. There is a wiki
article on the use of Oracle’s full text search support and I
am about to do the same with PostgreSQL’s full text support. I
will update the wiki when I have it done. I am not aware of any
other database’s that currently support full text indexing in
RT.

Cheers,
KenOn Tue, Jun 10, 2008 at 11:55:39AM +0200, Richard Hartmann wrote:

Hi all,

I was wondering if RT supports MySQL’s full text search feature [1].
As we are still using 3.4, I can not check this, myself.

Thanks for any hints/links,
Richard

[1] http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


#3

MySQL’s full text search is not supported with the INNODB tables
that are required for RT. It is not available.

OK, thanks. Perhaps I will try and grab the opportunity to migrate to
PostGRE :slight_smile:

Thanks,
Richard