Specifying character set using MySqlConnection

Connection string

This MySQL Connector/Net connection string can be used for connections to MySQL.

Use this one to specify which character set to use to encode queries sent to the server.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
CharSet=utf8;

Note! Use lower case value utf8 and not upper case UTF8 as this will fail.

Note that resultsets still are returned in the character set of the data returned.