Unicode special characters causing 'Incorrect String value' errors (MySQL)

[Nick-Lucas]

The following string threw on .Store()

Data came from a table in utf8 and was being stored to a table of utf8mb4

[Nick-Lucas]

Running the following will reliably reproduce this crash

        static void DB(MySqlConnection c) {
            string s = "INSERT INTO " + tbl + " SET title = @title, result_data = @data, run_on = @when";

            // Adding or removing this block will reproduce the error
            var set = c.CreateCommand();
            set.CommandText = "set names utf8mb4"; // or simply utf8
            set.ExecuteNonQuery();

            var cmd = c.CreateCommand();
            cmd.CommandText = s;
            cmd.Parameters.AddWithValue("title", title);
            cmd.Parameters.AddWithValue("data", data); // contains 'Ç'
            cmd.Parameters.AddWithValue("when", run_on);
            cmd.ExecuteNonQuery();

            Console.WriteLine("DB DONE");
            Console.Read();
        }

Need to investigate why set names is required in Limebean as so far it's causing 1 issue and no solutions compared my usage of ADO in the past

[Nick-Lucas]

This is due to the MariaDbDetails.cs class in Limebean running set names utf8mb4 as recommended here: http://dev.mysql.com/doc/refman/5.7/en/charset-connection.html

It seems not to set everything correctly, whereas adding: characterset=utf8mb4 to the connection string causes this to work. This implied some variable is set by the connection string which is not set by set names in MySQL.

Workaround is to include the charset in the connection string