Can't add Full text index

[Anon]

ALTER TABLE webindex.store_table ADD FULLTEXT INDEX store_index(store_name, store_info(500),store_keywords(500))

error
MySQL said: BLOB column 'store_info' can't be used in key specification with the used table type

Columns
store_name varchar(50)
store_info text
store_keywords text

I have looked at the manual
Just don't get why it don't work
have the latest version of mysql

[jburfield]

Try this:

ALTER TABLE webindex.store_table ADD FULLTEXT store_index(store_name, store_info(500),store_keywords(500))

Not 'FULLTEXT INDEX', just 'FULLTEXT'

-- Jason

[Anon]

Get the same error

[jburfield]

My bad...it should be this:

ALTER TABLE webindex.store_table ADD FULLTEXT store_index(store_name, store_info,store_keywords)

I don't believe you can do a sub index type deal [ (500) ] on a fulltext index.

This one works for sure.

-- Jason