乱码问题

Question

如题，链接数据库  结果 传过去中文 乱码了
<add name="mySql" connectionString="server=222.222.222.222;uid=222;pwd=222;database=222;charset=utf-8"/>
试了没效果，求救

Answer 1

encoding="utf-8"
编码问题

Answer 2

<add name="mySql" connectionString="server=222.222.222.222;uid=222;pwd=222;database=222;encoding=utf-8"/>报错 说是不支持

Answer 3

你的网站或程序编码是utf8么？

Answer 4

MySQLCommand setformat = new MySQLCommand("set names gb2312",m_Connection);
参考http://www.cnblogs.com/13590/archive/2010/04/17/1714157.html

Answer 5

public static DataTable getDataMySql(string sql, string connString)
        {
            using (MySqlConnection conn = new MySqlConnection(connectionString(connString)))
            {                using (MySqlCommand comm = new MySqlCommand(sql, conn))
                {
                    DataTable dt = new DataTable();
                    try
                    {
                        conn.Open();
                        MySqlDataAdapter sda = new MySqlDataAdapter();
                        sda.SelectCommand = comm;
                        sda.Fill(dt);
                    }
                    catch (Exception) { throw; }
                    finally
                    {
                        comm.Parameters.Clear();
                        comm.Dispose();
                        conn.Close();
                    }
                    return dt;
                }
            }
        }
这个set name应该怎么加呢

Answer 6

  using (MySqlCommand comm = new MySqlCommand("set names gb2312", conn))
                {
                    DataTable dt = new DataTable();
                    try
                    {
                        conn.Open();
                        comm.ExecuteNonQuery(); 
                        MySqlDataAdapter sda = new MySqlDataAdapter(sql,conn);
                        sda.Fill(dt);
                    }
                    catch (Exception) { throw; }
                    finally
                    {
                        comm.Parameters.Clear();
                        comm.Dispose();
                        conn.Close();
                    }
                    return dt;
                }

Answer 7

不行的话
参考一下这篇文章http://blog.sina.com.cn/s/blog_59d3f36a0100zow9.html