用 asp.net写了个插入语句,中文在插入数据库以后都变成了 问号(?)
MySqlobj mys = new MySqlobj();
string sqlstr = "insert into test (flag) VALUES ('中文')";
mys.ExecuteNonQuery(sqlstr);
#region 执行插入或删除操作
public int ExecuteNonQuery(string sqlString)
{
int ret = 0;
com.CommandText = sqlString;
com.CommandType = CommandType.Text;
try
{
ret = com.ExecuteNonQuery();
}
catch (Exception ee)
{
string ss = ee.Message;
ret = -1;
}
finally
{
com.Dispose();
}
return ret;
}
#endregion
mysql是 utf-8的asp.net在 web.conig里面设置了
<globalization fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8"/>
MySqlobj mys = new MySqlobj();
string sqlstr = "insert into test (flag) VALUES ('中文')";
mys.ExecuteNonQuery(sqlstr);
#region 执行插入或删除操作
public int ExecuteNonQuery(string sqlString)
{
int ret = 0;
com.CommandText = sqlString;
com.CommandType = CommandType.Text;
try
{
ret = com.ExecuteNonQuery();
}
catch (Exception ee)
{
string ss = ee.Message;
ret = -1;
}
finally
{
com.Dispose();
}
return ret;
}
#endregion
mysql是 utf-8的asp.net在 web.conig里面设置了
<globalization fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8"/>
在统一的字符集下插入数据