MySql.Data 链接MySql数据库 查询语句中带有中文的奇怪问题

首先Nuget管理器安装MySql.Data

 

 1、ado.net 直接链接

 public static void Test()
        {
            MySqlConnection myconn = null;

            MySqlCommand mycom = null;

            MySqlDataAdapter myrec = null;

            myconn = new MySqlConnection("server = 192.168.1.221;user id = pms; password=Zkhz123456; database=zentao;");

            myconn.Open();

            mycom = myconn.CreateCommand();

            mycom.CommandText = "SELECT `zt_user`.`account` AS `account`,`zt_user`.`realname` AS `realname` FROM `zt_user` AS `zt_user` WHERE `zt_user`.`realname` LIKE CONCAT('%','宋','%')";

            MySqlDataAdapter adap = new MySqlDataAdapter(mycom);

            DataSet ds = new DataSet();

            adap.Fill(ds);
        }

 实际数据库是有数据的。

 

修改数据库链接字符串如下：

new MySql.Data.MySqlClient.MySqlConnection("server = 192.168.1.221;user id = pms; password=Zkhz123456; database=zentao;charset=utf8");