Bug #80778 [NEW]: Cannot handle UTF8 characters when connected to a SAP HANA database

From: Date: Fri, 19 Feb 2021 17:21:53 +0000
Subject: Bug #80778 [NEW]: Cannot handle UTF8 characters when connected to a SAP HANA database
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-232290@lists.php.net to get a copy of this message 
From:             tony at tonymarston dot net
Operating system: Windows 10
PHP version:      7.4.15
Package:          ODBC related
Bug Type:         Bug
Bug description:Cannot handle UTF8 characters when connected to a SAP HANA database

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 bug report at https://bugs.php.net/bug.php?id=80778&edit=1
-- 
Fix committed:                    https://bugs.php.net/fix.php?id=80778&r=fixed
Fixed in release:                 https://bugs.php.net/fix.php?id=80778&r=alreadyfixed
Need backtrace:                   https://bugs.php.net/fix.php?id=80778&r=needtrace
Need Reproduce Script:            https://bugs.php.net/fix.php?id=80778&r=needscript
Try newer version:                https://bugs.php.net/fix.php?id=80778&r=oldversion
Not developer issue:              https://bugs.php.net/fix.php?id=80778&r=support
Expected behavior:                https://bugs.php.net/fix.php?id=80778&r=notwrong
Not enough info:                  https://bugs.php.net/fix.php?id=80778&r=notenoughinfo
Submitted twice:                  https://bugs.php.net/fix.php?id=80778&r=submittedtwice
register_globals:                 https://bugs.php.net/fix.php?id=80778&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=80778&r=phptooold
Daylight Savings:                 https://bugs.php.net/fix.php?id=80778&r=dst
IIS Stability:                    https://bugs.php.net/fix.php?id=80778&r=isapi
Install GNU Sed:                  https://bugs.php.net/fix.php?id=80778&r=gnused
Floating point limitations:       https://bugs.php.net/fix.php?id=80778&r=float
No Zend Extensions:               https://bugs.php.net/fix.php?id=80778&r=nozend
MySQL Configuration Error:        https://bugs.php.net/fix.php?id=80778&r=mysqlcfg

Thread (4 messages)

« previous php.bugs (#232290) next »