.net操作mysql中文字符乱码的问题

最新推荐文章于 2024-09-14 19:55:29 发布

weixin_34347651

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量71

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/bmate/archive/2010/04/14/1711791.html

版权

//写入数据库时进行转换

public string GB2312_ISO8859(string write)
{
    //声明字符集
    System.Text.Encoding iso8859, gb2312;
    //iso8859
    iso8859 = System.Text.Encoding.GetEncoding("iso8859-1");
    //国标2312
    gb2312 = System.Text.Encoding.GetEncoding("gb2312");
    byte[] gb;
    gb = gb2312.GetBytes(write);
    //返回转换后的字符
    return iso8859.GetString(gb);
}

//读出时进行转换

public string ISO8859_GB2312(string read)
{
    //声明字符集
    System.Text.Encoding iso8859, gb2312;
    //iso8859
    iso8859 = System.Text.Encoding.GetEncoding("iso8859-1");
    //国标2312
    gb2312 = System.Text.Encoding.GetEncoding("gb2312");
    byte[] iso;
    iso = iso8859.GetBytes(read);
    //返回转换后的字符
    return gb2312.GetString(iso);
}

//批量数据转换
//其实就是将dataset的内容读出到xml文件，然后再输出

public DataSet ISO8859_GB2312(DataSet ds)
{
    string xml;
    xml = ds.GetXml();
    ds.Clear();
    //声明字符集
    System.Text.Encoding iso8859, gb2312;
    //iso8859
    iso8859 = System.Text.Encoding.GetEncoding("iso8859-1");
    //国标2312
    gb2312 = System.Text.Encoding.GetEncoding("gb2312");
    byte[] bt;
    bt = iso8859.GetBytes(xml);
    xml = gb2312.GetString(bt);
    ds.ReadXml(new System.IO.StringReader(xml));
    return ds;
}