help enableing Fulltext in mysql

[djwinder]

I have been trying to enale fulltext on existing tables within my database. I have tried the code:

[SQL] ALTER TABLE stock ADD FULLTEXT(name, description, catagory); [/SQL]

which addresse the correct table and colums but i recive the following mysql error

"The used table type doesn't support FULLTEXT indexes"

any idea how i can enable FULLTEXT or change the table type?

Thanks

Dan

[Roger_Ramjet]

The Full Text Restrictions tell you that it only works on myisam tables. Change table type or search strategy.

[djwinder]

I have tried searching the manual for advice on how to change the table type but cant find any. any ideas how i could do this and would this change have obviouse negative effects on existing code or do the basic functions of Mysql work regardless of table type.

thanks

[Roger_Ramjet]

You will have to create new tables and copy the data across to them. There are some real differences between table types that will effect you if you are dependent on them - like transactions and performance. If you don't know of any dependencies chances are only relative performance will affect you.

Apart from that, you can mix and match table types in the same db and query.