Additional information: ‘windows-1252’ is not a supported encoding name. For information on defining a custom encoding,see the documentation for the Encoding.RegisterProvider method.

这是我的代码.

private async void Login(string passcode)
    {
        try
        {
            MysqLConnection conn = new MysqLConnection("Server=127.0.0.1;Port=3306;Database=database;Uid=username;Pwd=password;SslMode=None;charset=utf8");
            MysqLCommand cmd;

            conn.Open();

            cmd = new MysqLCommand("Select * from users where User = '" + passcode + "'",conn);

            MysqLDataReader dr;

            dr = cmd.ExecuteReader();

            int count = 0;

            while (dr.Read())
            {
                count += 1;
            }

            if(count == 1)
            {
                var dialog = new MessageDialog("Logged In");
                await dialog.ShowAsync();
            }
            else
            {
                var dialog = new MessageDialog("Error");
                await dialog.ShowAsync();
            }

        }
        catch (Exception ex)
        {
            if (ex is MysqLException)
            {
                MysqLException exl = (MysqLException)ex;
                var dialog = new MessageDialog(ex.Message + Environment.NewLine + exl.Number);
                await dialog.ShowAsync();
            }
            else
            {
                var dialog = new MessageDialog(ex.Message + Environment.NewLine);
                await dialog.ShowAsync();
            }

            //throw;
        }
        finally
        {
            conn.Close();
        }


    }
}

我在这行代码中得到了错误

dr = cmd.ExecuteReader();

在我习惯之前

conn.open();

但我能够通过添加来解决它

charset=utf8

到连接字符串.

我该如何解决这个错误？