如何在MySQL中将BLOB转换为TEXT? [英] How do I convert from BLOB to TEXT in MySQL?

问题描述

我有很多记录，其中文本已存储在MySQL的blob中.为了便于处理，我想将数据库中的格式更改为TEXT ...任何想法如何轻松进行更改以免打断数据-我想将需要对其进行正确编码?

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?

推荐答案

这是不必要的.只需使用SELECT CONVERT(column USING utf8) FROM .....而不只是SELECT column FROM ...

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

这篇关于如何在MySQL中将BLOB转换为TEXT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！