We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
摘抄自mysql blob类型转string的sql处理方式
查询
select CONVERT (columnName USING utf8) AS CONTENT from tableName;
新增
INSERT INTO tableName(columnName ) VALUES (cast('<p>中文英文html</p>'as char));
更新
update tableName set columnName =cast('<p>中文英文html</p>'as char);