SELECT auth, ip, CONVERT(CAST(address AS BINARY) USING 'gbk') FROM admins WHERE LENGTH(access)>3 可以用cast,convert函数让MYSQL直接返回指定的编码字符串. 经常忘记,做下笔记.