Bug #80778 [Opn->Fbk]: Cannot handle UTF8 characters when connected to a SAP HANA database

From: Date: Tue, 23 Feb 2021 10:49:48 +0000
Subject: Bug #80778 [Opn->Fbk]: Cannot handle UTF8 characters when connected to a SAP HANA database
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-232340@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=80778&edit=1

 ID:                 80778
 Updated by:         cmb@php.net
 Reported by:        tony at tonymarston dot net
 Summary:            Cannot handle UTF8 characters when connected to a
                     SAP HANA database
-Status:             Open
+Status:             Feedback
 Type:               Bug
 Package:            ODBC related
 Operating System:   Windows 10
 PHP Version:        7.4.15
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

Please provide a *minimal* reproduce script, and the according
ODBC backtrace[1]?

[1] <https://docs.oracle.com/cd/E17952_01/connector-odbc-en/connector-odbc-configuration-trace-windows.html>


Previous Comments:
------------------------------------------------------------------------
[2021-02-19 17:21:53] tony at tonymarston dot net

Description:
------------
I am running PHP 7.4.15 on Windows 10 and have connected to a SAP HANA database using the ODBC
driver. The HDBODBC version is 2.07.21 and I have added CHAR_AS_UTF8=TRUE to the ODBC connection
properties. I use the Eclipse plugin, which uses JDBC, as the tool to manage my databases. I have
the same databases available in MySQL, Oracle and SQL Server and those can deal with UTF8
characters, but HANA does not seem to like them at all. If I input the string
'Neuchâtel' using Eclipse it shows up in PHP as 'NEUCHâTEL'. If I
update the value in PHP and then retrieve it, it shows up as 'NEUCHâTEL'.
Note that while Eclipse shows them as mixed case strings in PHP they are all shifted to upper case.

Expected result:
----------------
I expect the ODBC driver to both read and write UTF8 characters properly, and not shift everything
to uppercase when reading them.



------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=80778&edit=1

Thread (4 messages)

« previous php.bugs (#232340) next »