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

首先Nuget管理器安装MySql.Data

 

 1、ado.net 直接链接

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

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");