MySQLDriverCS 中文乱码 问题解决
使用MySQLDriverCS 类操作MySql数据库时遇到中文乱码的问题,解决如下:
在执行SQL语句前,设置一下编码 set names gb2312 示例如下:
//Some thing here
MySQLConnection myConn = new MySQLConnection(mySqlConnectionString);
myConn.Open();
MySQLCommand firstCmd = new MySQLCommand("set names gb2312", myConn);
firstCmd.ExecuteNonQuery();
string Sql = "select * from hooyes";
MySQLCommand cmd = new MySQLCommand();
cmd.Connection = myConn;
cmd.CommandText = Sql;
MySQLDataReader dr= cmd.ExecuteReaderEx();
//.
MySQLConnection myConn = new MySQLConnection(mySqlConnectionString);
myConn.Open();
MySQLCommand firstCmd = new MySQLCommand("set names gb2312", myConn);
firstCmd.ExecuteNonQuery();
string Sql = "select * from hooyes";
MySQLCommand cmd = new MySQLCommand();
cmd.Connection = myConn;
cmd.CommandText = Sql;
MySQLDataReader dr= cmd.ExecuteReaderEx();
//.
附:
MySQLDriverCS: An C# driver for MySQL. MySQLDriverCs 提供类似 SQLhelper 的方法访问 MySql 数据库,可以当它是一个 MySqlHelper 吧:)
MySQLDriverCS 下载:
本地: /Files/hooyes/MySQLDriverCS.rar