数据库Connection和字段的字符集都采用utf-8.
开始使用存储过程插入数据,代码大约如下
MySqlCommand cmd = new MySqlCommand("apend_testproject",
new MySqlConnection(cConnectMySqlHelp.GetConnectStr().ConnectionString));
commonfunc.logfile(cmd.Connection.ConnectionString);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("_PM", _PM));
cmd.Parameters.Add(new MySqlParameter("_PUBLISH_TIME", _PUBLISH_TIME));
cmd.Parameters.Add(new MySqlParameter("_PRODUCT_LINE", _PRODUCT_LINE));
cmd.Parameters.Add(new MySqlParameter("_NAME", HttpUtility.UrlDecode(_NAME)));
cmd.Parameters.Add(new MySqlParameter("_PROGRESS", 100));
cmd.Parameters.Add(new MySqlParameter("_TEST_SUB_TIME", _TEST_SUB_TIME));
cmd.Parameters.Add(new MySqlParameter("_PROJECT_TYPE", _PROJECT_TYPE));
结果数据库表中显示