MySQL not allowing text columns? I'm using MySQL 5.5.27. I currently have a BLOB column, that I want to convert to text to allow fulltext searching. The ALTER TABLE command to create a text column is successful, but the ALTER TABLE table ADD FULLTEXT INDEX index (column ASC) to create a fulltext index returns an error, saying I cannot create a fulltext index on that column. 

When I go back and look at the specs for the table, it appears as BLOB, instead of text.

I'm using MySQLWorkbench, but I've generally been running the scripts by hand, instead of using the wizard.

I have tried setting a character encoding for the entire schema (none existed before) thinking that this would be needed for text columns, but it didn't help.
The command

ALTER TABLE ADD FULLTEXT INDEX index (column ASC);


sounds like it does not make sense.

What does FULLTEXT indexing a column in ascending order mean?

You should run it like this:

ALTER TABLE ADD FULLTEXT INDEX index (column);


Give it a Try !!!