MySQL ODBC 3.51 Driver UTF-8 encoding

Question

Currently I am migrating MSSQL to MYSQL.I am using the MySQL ODBC 3.51 driver to connect to mysql using odbc connectivity.I have telugu language charectors stored in the table.They are not showing properly while using the mysql odbc driver, but they are showing up properly while using the sqlserver odbc driver.

Here is my connetion string

Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=dbtest; User=user1;Password=mysql;Option=3;CharSet=utf8;

Please suggest a solution to fix this.

Answer 1

According to this you can make it work by setting the DNS's 'Connect Options'->'Initial Statement' to 'SET NAMES utf8'.