如何在 MySQL 中从 BLOB 转换为 TEXT?
我有很多记录，其中文本已存储在 MySQL 的 blob 中.为了便于处理，我想将数据库中的格式更改为文本...任何想法如何轻松进行更改以免中断数据 - 我想它需要正确编码?
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...
相关文章