c# mysql 编码_用C#往MySql数据库表中插入中文，显示的全是问号

部分代码如下：stringsaveStudent="insertintotestvalues("+schoolID+",'"+schoolName+"',"+gradeNum+","+classNum+","+studentID+",'"+studentName+"',"+chinese+","+math+","+physi...

部分代码如下：

string saveStudent = "insert into test values ("

+ schoolID + " , '"

+ schoolName + " ' ,"

+ gradeNum + " , "

+ classNum + " , "

+ studentID + " , '"

+ studentName + "' ,"

+ chinese + " , "

+ math + " , "

+ physics + " , "

+ chemistry + " , "

+ biology + ")";

command = new MySqlCommand(saveStudent, conn);

command.ExecuteNonQuery();

其中schoolName和studentName均为中文字。方法也试过很多了，修改my.ini和修改MySql默认字符集等等都没有用，怀疑是在插入数据的时候出的问题，求高手解答

展开