Specifying character set using MySQL ODBC 5.1
Connection string
This MySQL Connector/ODBC 5.1 connection string can be used for connections to MySQL.
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;charset=UTF8;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;