How do I change a MySQL data field in a table from BLOB to text?

Answer 1

if you didn't need the data in your blob field , simply drop the field and recreate it again with new fieldtype (e.g. text fieldtype).

but, if you need it (i assume your blob field contain text / memo) ,
that is another story.
most of database will reject and give you an 'error message' if you trying to copy the records from blob field to Text field.
I've never try to use 'CAST' or some convertion query to convert blob field to another type, but it's worth to try.

Ask again in this forum if you get stuck, we will try to find the solution for you.

Answer 2

Blob fields can hold any kind of binary data, so the procedure of converting that data to text is going to depend entirely on what that data is.

In short - create a new field in the table, and write some code that goes through the table record by record, converting as it goes. As I've said, the conversion will depend on what the blob data is in the first place.

Rawlyn.