用 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"/>
在统一的字符集下重新建立表、库。再导入数据