database problem in searching

[jairoh_]

mga boss nganung akong table di ka support ug fulltext searching? kaguol oe. newbie pako dbms. anyone can help. tnx

[chrisvil]

bisan unsa na RDBMS or DBMS mo support gyud na. Elaborate nu imo problema.

[jairoh_]

mao ni error boss: #1214 - The used table type doesn't support FULLTEXT indexes

[chrisvil]

Full-text search is supported only on MyISAM table type.

ALTER TABLE my_table ENGINE = MYISAM;

Do this before the FullText add, even if the engine database default is already MyISAM

[Rickstar13]

naka gamit ko og fulltext on MsSQl Server. hehe

[jairoh_]

ok na cya mga boss. lamat au