Hebrew chars retrieved and presented as gibberish through ODBC 5.3
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;
Subject
Written By
Posted
Hebrew chars retrieved and presented as gibberish through ODBC 5.3
May 27, 2018 11:46AM
Sorry, you can't reply to this topic. It has been closed.
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.