ASP.NET+MYSQL,无法向Mysql存入中文?

Question

在线等..

Answer 1

using System.Data.SqlClient;
using MySql.Data.MySqlClient;
string sqlstring="insert into tblTest (fldTit,fldContent,fldSign,fldDate)  values  ('标题0','实际内容0','0','2008-9-27 15:12:42  )";        using (MySqlConnection connMain = new MySqlConnection("server=localhost;user id=root;password=psd;database=sqlTest_lib"))
        {
            MySqlCommand cmdMain = new MySqlCommand(sqlstring, connMain);
            MySqlCommand myCommand = new MySqlCommand(sqlstring, connMain);
            connMain.Open();
            
            try
            {
                myCommand.ExecuteNonQuery();
            }
            catch (Exception E)
            {
                HttpContext.Current.Response.Redirect("ErrorInfo.aspx?ErrorInfo=" + HttpContext.Current.Server.UrlEncode(E.Message), false);
            }
            finally
            {
                cmdMain.Dispose();
                connMain.Close();
                connMain.Dispose();
            }
        }

Answer 2

连接字符串里加一个charset=gb3212试试