Extent passing string to database with utf8 encoding results in invalid chars

[Sven Bisaro]

This is the code that I use to insert the value in the test database:

string connectionString ="Database=monkey; Data Source=localhost;

UserId=<user>; Password=<pwd>; CharSet=utf8";

MySqlConnection con=new MySqlConnection(connectionString);

con.Open();

string sql="insert into tbl_monkey(monkey_name) values('ä')";

MySqlCommand cmd = new MySqlCommand(sql,con);

cmd.ExecuteNonQuery();

con.Close();

This is the result:

+--------------+-------------+
| pk_monkey_id | monkey_name
+--------------+-------------+
| 1 | Σ |
| 2 | Σ |
| 3 | Σ |
+--------------+-------------+

Can someone indicate how I can get ä into my database?

Thanks
Sven