Pomelo.Data.MyCat icon indicating copy to clipboard operation
Pomelo.Data.MyCat copied to clipboard

Mycat 连sql server中文乱码

Open xBoo opened this issue 7 years ago • 2 comments

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>

xBoo avatar Jun 15 '17 07:06 xBoo

` 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();
        }` 

xBoo avatar Jun 15 '17 07:06 xBoo

同样问题

MetSystem avatar Feb 24 '18 08:02 MetSystem