mysql数据库编码与字段编码都为utf8时,写入中文不乱码的方法:
1、读取mysql时,采用与mysql 相同的编码方式,如:set character_set_results=utf8mb4,保证读入中文不乱码
2、对字符串操作时,源字符串与目标字符要保持相同的编码
3、写入mysql时,set names gbk,同时sql语句与变量都采用gbk编码
读取代码:
cMysql.SqlQuery(“set character_set_results=utf8mb4”, res, errormsg);
写入代码:
cMysql.SqlQuery(“set names gbk”, wres, werrormsg);
部分代码如下:
// 读取时
mysqlpp::StoreQueryResult res;
DBmysql cMysql = gDBWork.GetMysql();
string errormsg;
cMysql.SqlQuery("set character_set_results=utf8mb4", res, errormsg);
cMysql.SqlQuery(strSql, res, errormsg);
// 写入时
new_actionLabel = UTF8ToGBK(new_actionLabel.c_str());
std::stringstream w_sql;
w_sql << "update prs_userprofile set ActionLabel ='";
w_sql << new_actionLabel.c_str();
w_sql << "' WHERE UserID = '";
w_sql << userid.c_str();
w_sql << "'";
string strWSql = w_sql.str();
mysqlpp::StoreQueryResult wres;
LLOG_INFO("write sql : %s", strWSql);
string werrormsg;
cMysql = gDBWork.GetMysql();
cMysql.SqlQuery("set names gbk", wres, werrormsg);
cMysql.SqlQuery(strWSql, wres, werrormsg);