C# mysql 乱码问题
来源:百度知道 编辑:UC知道 时间:2024/09/23 03:20:57
OdbcConnection myConnection=null;
string strconn = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydb;User=root; Password=test;Charset=UTF8;Option=3;STMT=SET CHARACTER SET UTF8;";
myConnection = new OdbcConnection(strconn);
myConnection.Open();
OdbcCommand myCommand = new OdbcCommand(sql, myConnection);
//OdbcDataReader DbReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
OdbcDataReader DbReader = myCommand.ExecuteReader();
为什么还是乱码
不解 什么意思
mysql 编码也是utf8
string strconn = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydb;User=root; Password=test;Charset=UTF8;Option=3;STMT=SET CHARACTER SET UTF8;";
myConnection = new OdbcConnection(strconn);
myConnection.Open();
OdbcCommand myCommand = new OdbcCommand(sql, myConnection);
//OdbcDataReader DbReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
OdbcDataReader DbReader = myCommand.ExecuteReader();
为什么还是乱码
不解 什么意思
mysql 编码也是utf8
你看看你MySql配置的时候编码是不是 UTF8,要是不是的话,当然会出现乱码啦
OdbcConnection myConnection=null; //初始化链接对象
string strconn = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydb;User=root; Password=test;Charset=UTF8;Option=3;STMT=SET CHARACTER SET UTF8;";//连接配置
myConnection = new OdbcConnection(strconn); //实例化对象,名为myConnection
OdbcCommand myCommand = new OdbcCommand(sql, myConnection);//实例化,创建Command对象,准备对数据库进行操作
OdbcDataReader DbReader = myCommand.ExecuteReader(); //返回一个影响值
myConnection.Open();//打开数据库