"Incorrect string value" error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
vk2022
Posts: 1
Joined: Fri 27 May 2022 19:46

"Incorrect string value" error

Post by vk2022 » Fri 27 May 2022 20:02

I have next code that fails with "Incorrect string value" error.
My column character set is latin1, and character that is failing is '°C' degree (which is in latin1 character set).
Same code using MySql.Data v8.0.28.0 is working.

static public bool AddResults(string testId, string xml)
{
var conn = new Devart.Data.MySql.MySqlConnection("Server=localhost;Database=db;Uid=root;Pwd=root;");
try
{
conn.Open();
var sql = $"INSERT INTO resultpools (TestID, Pool) VALUES (@TestID, @Pool)";
var cmd = new Devart.Data.MySql.MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@TestID", testId);
cmd.Parameters.AddWithValue("@Pool", xml);
return cmd.ExecuteNonQuery() > 0;
}
finally
{
conn.Close();
}
}

DmitryGm
Devart Team
Posts: 152
Joined: Fri 11 Dec 2020 10:27

Re: "Incorrect string value" error

Post by DmitryGm » Wed 29 Jun 2022 11:43

Set "Unicode=True;" in the connection string.

https://www.devart.com/dotconnect/mysql ... tring.html

Unicode: Sets client charset to utf8mb4 for MySQL 5.5.3 and higher or to utf8 for MySQL versions lower than 5.5.3 and converts client data according to this charset.

Post Reply