Special characters replaced with question marks in MySql response from .net using MySqlConnection

Question

I am using MySqlConnection in my .net application to query a MySql Database from a .net application, but special characters (it is in Danish) in my resultset is shown as question marks. I have tried including "charset" (charset=utf8) in my connection string without any luck.

first check your table which character4set and collation it s using maybe it isn't utf8 — nbk, Sep 25 '19 at 17:22
Thanks very much for your reply! The table is set to latin1_danish_ci — PNR, Sep 25 '19 at 17:42

score 0 · Answer 1 · answered Sep 25 '19 at 20:36

try connection with

Server=localhost;Port=3306;Database=xxx;Uid=x xx;Pwd=xxxx;CHARSET=latin1;

And then

partial void OnContextCreated()
{
    System.Data.Common.DbCommand command = this.Connection.CreateCommand();
    command.CommandText = "set collation_connection = utf8_slovenian_ci;";
    command.CommandType = System.Data.CommandType.Text;
    this.Connection.Open();
    command.ExecuteNonQuery();
}

like described here Database connection string and collation

Special characters replaced with question marks in MySql response from .net using MySqlConnection

1 Answers1