MySQLConnection ms_Conn;
MySQLDataReader ms_Datareader;
MySQLCommand ms_Commn;
MySQLDataAdapter ms_DataAdapter;
ms_Conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1", "database", "root", "root").AsString);
ms_Conn.Open(); ms_Commn = new MySQLCommand("set names gb2312", ms_Conn);
ms_Commn.ExecuteNonQuery(); ms_Commn = new MySQLCommand("select CONTENT from ecs_article ", ms_Conn); ms_Datareader = ms_Commn.ExecuteReaderEx();
while (ms_Datareader.Read())
{
byte[] buf = new byte[1024 * 10]; string s = ms_Datareader["CONTENT"].ToString(); System.Text.Encoding.GetEncoding(28591).GetBytes(s, 0, s.Length, buf, 0); s = System.Text.Encoding.Default.GetString(buf); StreamWriter sw = File.AppendText(Server.MapPath(".") + "\\Content.txt");
sw.WriteLine(s);
sw.Flush();
sw.Close(); }
ms_Conn.Close();
我就是这样读取的.可是为什么不对啊.读出来的是system.byte[].急啊~~~求高手看看啊.
查了N个贴了,初步判断问题出在字符集是.可是如何解决啊.我用的是MySQLDriverCS
还有如果我想写入这个字段如何写啊...
MySQLDataReader ms_Datareader;
MySQLCommand ms_Commn;
MySQLDataAdapter ms_DataAdapter;
ms_Conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1", "database", "root", "root").AsString);
ms_Conn.Open(); ms_Commn = new MySQLCommand("set names gb2312", ms_Conn);
ms_Commn.ExecuteNonQuery(); ms_Commn = new MySQLCommand("select CONTENT from ecs_article ", ms_Conn); ms_Datareader = ms_Commn.ExecuteReaderEx();
while (ms_Datareader.Read())
{
byte[] buf = new byte[1024 * 10]; string s = ms_Datareader["CONTENT"].ToString(); System.Text.Encoding.GetEncoding(28591).GetBytes(s, 0, s.Length, buf, 0); s = System.Text.Encoding.Default.GetString(buf); StreamWriter sw = File.AppendText(Server.MapPath(".") + "\\Content.txt");
sw.WriteLine(s);
sw.Flush();
sw.Close(); }
ms_Conn.Close();
我就是这样读取的.可是为什么不对啊.读出来的是system.byte[].急啊~~~求高手看看啊.
查了N个贴了,初步判断问题出在字符集是.可是如何解决啊.我用的是MySQLDriverCS
还有如果我想写入这个字段如何写啊...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货