MySQL Forums
Forum List  »  Full-Text Search

Table Types
Posted by: Tijana Momirov
Date: October 31, 2006 04:30AM

My question is about MySQL table types when implementing fulltext search. It is said that for fulltext search MyISAM tables are needed, but on the other hand I need my tables to be of InnoDB type because of many foreign keys I use. Is there a way to have both features within a table (foreign keys and fulltext search)?

P.S. I read that for boolean fulltext search indexes are not obligatory, but anyway it doesn't work on my InnoDB tables.


Options: ReplyQuote

Written By
Table Types
October 31, 2006 04:30AM
November 03, 2006 07:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.