SAP HANA ODBC driver is broken

Question

I have recently installed a SAP HANA virtual machine on one of my Windows PCs and can connect to it using my PHP application and the Eclipse plugin. I have created several databases and can read from and write to them from my application, but I have hit two problems:

1. It does not handle UTF8 characters correctly.
2. It randomly shifts some text strings to uppercase.

My PHP version is 7.4.14 and the HDBODBC driver version is 2.06.64.28100.

When I examine the data using Eclipse it is exactly as it should be, but when I retrieve it through PHP it exhibits the above problems. I have also used another 3rd party ODBC Query Tool which uses the same HDBODBC driver and it suffers from the same problems, so I know that it's not a PHP problem.

Does anyone have any ideas?

question from:https://stackoverflow.com/questions/66050434/sap-hana-odbc-driver-is-broken

Answer 1

Waitting for answers