将MySQL查询的输出转换为utf8 [英] Convert output of MySQL query to utf8

问题描述

我的数据库中有一个表，我想运行类似的查询

I have a table in my database and I want run a query like

SELECT column1, column2 FROM my_table WHERE my_condition;

但是我希望mysql以utf8编码返回column2.在mysql中有任何功能可以执行此类任务吗?那是什么?

but I want the mysql to return the column2 in utf8 encoding. Is it any function in mysql to do such task? What is that?

推荐答案

您可以使用CAST和CONVERT在不同类型的编码之间进行切换.参见: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html

You can use CAST and CONVERT to switch between different types of encodings. See: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html

SELECT column1, CONVERT(column2 USING utf8)
FROM my_table 
WHERE my_condition;

这篇关于将MySQL查询的输出转换为utf8的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！