MySQL table not supporting FULLTEXT index

I am using MySQL with InnoDB engine for my website. While creating a table with FULLTEXT index, it is throwing an error:

"The used table type doesn't support fulltext indexs"

What are t开发者_StackOverflow社区he alternatives I can use? I don't want to use MyISAM because InnoDB is more advanced. Any way to remove this error?

I am using PHP, MySQL, Apache on Windows machine.

---

FULLTEXT indexes are only supported by the MyISAM engine ; so, if you want your table to be in InnoDB, you won't have much of a choice.

If fulltext searching is an important part of your website/application, you might want to use something else than database, for the indexing/searching part -- typically, some dedicated solution, like Solr.

---

Wait until MySQL 5.6 - InnoDB is going to support FULLTEXT searches since then ;)

But if you can't wait, you can use for example SphinxSE, which lets you use Sphinx fulltext search engine on your MySQL tables with plain SQL