MySQL ODBC 3.51 Driver UTF-8 encoding
13,796
According to this you can make it work by setting the DNS's 'Connect Options'->'Initial Statement' to 'SET NAMES utf8'.
Author by
Admin
Updated on June 04, 2022Comments
-
Admin almost 2 years
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 characters 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.
My connection string is
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.