Question Re: Text strings read into a PHP application being converted to uppercase in Technology Q&A

Text strings read into a PHP application being converted to uppercase

Former Member — Tue, 26 Jan 2021 15:37:55 GMT

I have installed HANA Express Edition on a Windows 10 PC which I am accessing via a PHP application. I have created several tables in several database, but when I insert data with text in lower case it is being returned in uppercase when I read it back. When I look at the same data using Eclipse Hana Tools the text is shown in the same case as it was entered. Eclipse uses a JDBC connector while PHP uses the ODBC driver, so I am wondering whether there is a problem with the ODBC driver or the php_odb.dll library.

My ODBC driver version is 2.06.64.28100 and my PHP version is 7.4.14

Re: Text strings read into a PHP application being converted to uppercase

jeff_albion — Tue, 25 May 2021 17:43:09 GMT

Hi Anthony,

Can you post an example PHP script you have tried? Which PHP ODBC interface are you using: uodbc or pdo_odbc?

Jeff

Re: Text strings read into a PHP application being converted to uppercase

Former Member — Tue, 25 May 2021 17:56:28 GMT

It is not the identifier which is uppercased, it is the value for that identifier. In order to force all searches on text fields to be case insensitive I am using SET SESSION 'CASE_SENSITIVE'='FALSE' on each connection. Unfortunately I have discovered that, unlike all the other DBMS engines, SAP HANA can only perform a case-insensitive search by upshifting all the values before the comparison. This means that the value in the database may contain lower-case characters in the database they are all upshifted by the time they appear in the result set. What a bummer!