Specifying character set using MySQL ODBC 3.51 Driver
Connection string
This MySQL Connector/ODBC 3.51 connection string can be used for connections to MySQL.
Driver={MySQL ODBC 3.51 Driver};Server=myServerAddress;charset=UTF8;
Database=myDataBase;User=myUsername;Password=myPassword;Option=3;
Note that the charset option works from version 3.51.17 of the driver.