ALTERing Table Fields From BLOB to TEXT

[smays]

I am certain this will be considered 'bad form', but...I have a table with several fields each containing several kBytes of ASCII text data separated by a Winderz new line ('\n' ==> 0x0A). The fields are currently set up as BLOB fields and...I would like to ALTER the table to change the fields to TEXT fields. Will ALTERing the table to change the fields from BLOB to TEXT fields corrupt the text data? I am literally in complete control of how the data is placed in the table and how data is retrieved from the table.

Thanks,
Steve.

 

[r937]

create a test table with BLOB columns, populate with a few rows, and then do your ALTER TABLE to change the BLOB to TEXT

what happens when you test it?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[smays]

I get the idea. I can take the .sql file from a recent backup, 'install' the table on the server on my laptop and try it there.

Thanks,
Steve.