MySQL Forums
Forum List  »  Connector/ODBC

Hebrew chars retrieved and presented as gibberish through ODBC 5.3
Posted by: Mor Sagmon
Date: May 27, 2018 11:46AM

I'm connecting to MySQL Server 8.0.11 using Excel VBA using ODBC 5.3 driver:
[MySQL][ODBC 5.3(w) Driver][mysqld-8.0.11]

When storing Hebrew characters in the DB, they are stored OK in the DB (I see it in the MySQL Workbench), but they are presented as gibberish when retreived back to Excel through the ODBC driver. For example, these are the chars I see instead of beautiful Hebrew characters: ׳ž׳×׳—׳× ׳œ׳§׳¨׳•׳•׳׳Ÿ

What is going wrong here, please?

my.ini has:
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

Connection string (ADODB):

Driver={MySQL ODBC 5.3 Unicode Driver};Server=localhost;Port=3306;Database=xxx;Uid=xxx;Pwd=xxx;charset=UTF8;OPTION=16427;

Options: ReplyQuote


Subject
Written By
Posted
Hebrew chars retrieved and presented as gibberish through ODBC 5.3
May 27, 2018 11:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.