Pomelo.Data.MyCat
Pomelo.Data.MyCat copied to clipboard
Mycat 连sql server中文乱码
Hi,我这边使用mycat连SQL server,查询出现中文乱码,请大神看下是何问题?
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
</schema>
<dataNode name="dn1" dataHost="localhost1" database="Group.ERP" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="sqlserver" dbDriver="jdbc" switchType="1" slaveThreshold="100">
<heartbeat>select 1</heartbeat>
<!-- can have multi write hosts -->
<connectionInitSql></connectionInitSql>
<writeHost host="hostM1" url="jdbc:sqlserver://192.168.117.109:1433?characterEncoding=gbk" user="sa" password="sql">
</writeHost>
<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
</dataHost>
</mycat:schema>
` string sql = @"SELECT TOP 1 [CompanyName] FROM[Group.ERP].[dbo].[CostCompany]"; MyCatConnection conn = new MyCatConnection("Database=TESTDB;Data Source=192.168.117.200;User Id=root;Password=123456;pooling=false;port=8066"); MyCatCommand cmd = new MyCatCommand(sql, conn); conn.Open(); MyCatDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { var aaa = reader[0];
Console.WriteLine($"{reader[0]}");
}
}
finally
{
reader.Close();
}`
同样问题