How to Alter a table wich has tinyblob fields to Chars

[reddymade]

I have the following table with lots of data in it:

CREATE TABLE /!32300 IF NOT EXISTS/ [db_prefix]reference_lang_spr (
id bigint(11) NOT NULL auto_increment,
table_key int(3) NOT NULL default '0',
id_reference int(11) NOT NULL default '0',
lang_1 tinyblob,
lang_2 tinyblob,
lang_3 tinyblob,
lang_4 tinyblob,
lang_5 tinyblob,
PRIMARY KEY (id)
);

I would like to alter the table fields datatype for tinyblob's to text fields which is equalant in size of tiny blobs. I do have lot of data in the table.

Please is it possible to alter the table.

Thank you very much for the information.

[subwayman]

Well, I did't know the answer to this so I tried it. Took 3 minutes to create a table with a text field, add some records, alter the table to change the field to blob, check the records still have data and then alter the column back to text. Hey, it worked the original data was restored. I would still back up your table first though - just in case....