How do I convert from BLOB to TEXT in Mysql?

Question

Hiya,

I have a whole lot of records where text has been stored in a blob in MYSQL. For ease of handling I'd like to change the format in the DB to TEXT .. any ideas how easily to make the change so as not to interrupt the data - I guess it will need to be encoded properly?

Answer 1

After some googling for you i've found this. It's an answer to a person who wants to convert blob to char(1000) with utf8 encoding

CAST(a.ar_options AS CHAR(10000) CHARACTER SET utf8)

This is his answer. There is probably much more you can read about CAST right here. Hope it helps some.

Answer 2

Excellent work, well done Olafur!