Vba Adodb Query Mysql Returns Character Corruption

Sub hh() Dim sql As String Dim rs As New ADODB.Recordset Dim con As ADODB.Connection Dim dbConnStr As String dbConnStr = 'Driver={MySQL ODBC 5.2 ANSI DRIVER}; SERVER=localhost; DAT

Solution 1:

It looks like you are using UNICODE characters. Please note that the ODBC driver comes in two flavours: ANSI and UNICODE. The latter is more appropriate to your situation. Use MySQL ODBC UNICODE Driver and you'll be good. Arigatou!