连接到MYSQL数据库错误（UWP C＃） [英] Connecting to MYSQL database error (UWP C#)

问题描述

我为Windows 10桌面编写UWP应用

I writing UWP app for windows 10 desktop

我试图连接到服务器上的数据库

I trying to connect to DB on server

我代码：

 using (MySqlConnection connection = new MySqlConnection("Database= milano_app2;Data Source=IP_OF_SERVER;User Id=USERNAME;Password=;SslMode=None;"))
        {
            connection.Open();


            MySqlCommand createCommand = new MySqlCommand("CREATE TABLE demotable(salary int,surname varchar(255))", connection);
            createCommand.ExecuteNonQuery();


            MySqlCommand addCommand = new MySqlCommand("INSERT INTO demotable (salary,surname) VALUES (1234,'Вейдер')", connection);
            addCommand.ExecuteNonQuery();

        }

但是当我启动应用程序时，我会遇到此错误

But when I launch app i have this error

我认为BD编码存在问题？

I think problem in encoding of BD?

如何使它成为UTF-8？

How I can make it UTF-8?

感谢帮助。

推荐答案

将CharSet = utf8添加到连接字符串：

Add CharSet=utf8 to connection string :

"Database= milano_app2;Data Source=IP_OF_SERVER;User Id=USERNAME;Password=;SslMode=None;CharSet=utf8;"

这篇关于连接到MYSQL数据库错误（UWP C＃）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！