c# mysql 汉字乱码_C#使用string类变量，通过MySQLDriverCS类库给MySQL数据库插入中文时，插入结果显示为乱码，如图。求解决...

插入语句如下：stringquery="insertintoalllessons(academy,lessonno,lessonname,credit,classperiod,practiceperiod,computerperiod,category,property,teacher,classroom,weekday,c...

插入语句如下：

string query = "insert into alllessons(academy,lessonno,lessonname,credit,classperiod,practiceperiod,computerperiod,category,property,teacher,classroom,weekday,classtime,weektime,studentnumber,object,againornot,campus,year,semester) values ('" + academy + "','" + lessonno + "','" + lessonname + "','" + credit + "','" + classperiod + "','" + practiceperiod + "','" + computerperiod + "','" + category + "','" + property + "','" + teacher + "','" + classroom + "','" + weekday + "','" + classtime + "','" + weektime + "','" + studentnumber + "','" + Object + "','" + againornot + "','" + campus + "','" + Year + "','" + Semester + "')";

MySQLCommand cmd = new MySQLCommand(query, conn);

cmd.ExecuteNonQuery();

展开