Mysql – How to convert from BLOB to TEXT in MySQL

blobsmysqlsql

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 database 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?

Best Solution

That's unnecessary. Just use SELECT CONVERT(column USING utf8) FROM..... instead of just SELECT column FROM...