Enable FULLTEXT

pearl2 · #1 (**permalink**) 09-23-07, 23:09

Hello all,

I've a table that stores forum messages. The message column uses InnoDB which, as far as I understand, does not support FULLTEXT. I would like to add a search feature to the forum and I'm wondering if I should convert the InnoDB engine to MyISAM to take advantage of its FULLTEXT capability.

Another option I'm thinking of is to create another table that (sort of) mirrors the forum table, but which uses MyISAM. With this option, I can retain the original InnoDB forum table as I feel it's important to have Rollback capability.

What is the best approach I should take?

r937 · #2 (**permalink**) 09-23-07, 23:12

i think you just answered your own question

pearl2 · #3 (**permalink**) 09-23-07, 23:20

Quote:

Originally Posted by r937

i think you just answered your own question

Thanks, r937

Do you mean this one: Another option I'm thinking of is to create another table that (sort of) mirrors the forum table, but which uses MyISAM. With this option, I can retain the original InnoDB forum table as I feel it's important to have Rollback capability.?