MySqlCommand Command = new MySqlCommand("insert into mytest (name) values(?p_name)", Connection);
Command.CommandType = CommandType.StoredProcedure;
MySqlParameter p_sno = new MySqlParameter("?p_name", MySqlDbType.VarChar,20);
p_sno.Value = this.TextBox1.Text;
Command.Parameters.Add(p_sno);
能够插入汉字,显示也正常,改成下面的存储过程汉字就变成了??
CREATE PROCEDURE proc_mytest(
p_name VARCHAR(20))
BEGIN
insert into mytest (name) values(p_name);
END$$
Command.CommandType = CommandType.StoredProcedure;
MySqlParameter p_sno = new MySqlParameter("?p_name", MySqlDbType.VarChar,20);
p_sno.Value = this.TextBox1.Text;
Command.Parameters.Add(p_sno);
能够插入汉字,显示也正常,改成下面的存储过程汉字就变成了??
CREATE PROCEDURE proc_mytest(
p_name VARCHAR(20))
BEGIN
insert into mytest (name) values(p_name);
END$$
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货