From: marquis at us dot ibm dot com Operating system: Fedora 9 PHP version: 5.2.8 PHP Bug Type: ODBC related Bug description: php-odbc SQLBindCol() not used correctly
Description: ------------ PHP applications that use the iSeries Access for Linux ODBC driver to SELECT CHAR data containing characters outside the invariant character set (for example: "ü"), and using a UTF-8 locale, may receive extra garbage data at the end of the character string. This is caused by PHP passing an insufficient target length on the call to SQLBindCol(). PHP is setting the incorrect buffer length by using SQLColAttributes to return the SQL_COLUMN_DISPLAY_SIZE. I have seen this behavior on PHP 5.1 and 5.2.6-2 This problem also exists in PHP for Windows. The iSeries Access for Linux ODBC driver correctly returns error message : CWB0111 - A buffer passed to a system call is too small to hold return data However, the ODBC driver will be changed to not return the extra garbage data at the end of the CHAR string when using a connection string keyword option. PHP applications could then ignore the CWB0111 error message. For PHP applications using the UTF8 locale to use this workaround and prevent the extra garbage data, the odbc connection must pass in the following connection string keyword: DEBUG = 65536 Additional options: PHP does not calculate all buffer lengths using SQL_COLUMN_DISPLAY SIZE, so, PHP developers could use other SQL column types such as: SQL_BINARY, SQL_VARBINARY, SQL_LONGVARBINARY or SQL_LONGVARCHAR. No binding occurs with those data types and SQLGetData() is used to retrieve the value. For long data it may be neccessary to call PHP ODBC API odbc_longread() (http://us3.php.net/odbc_longreadlen) , because that is the length to be used for the buffer. If less data is available, PHP shrinks the buffer, but if more data is available, truncation will occur. Ref IBM APAR SE33393 http://www-912.ibm.com/n_dir/nas4apar.nsf/ALLAPARS/SE33393 The ideal solution would be for PHP to use the correct buffer length on the call to SQLBindCol(). Reproduce code: --------------- #!/usr/bin/php <? //setlocale(LC_ALL, 'de_DE'); $link = odbc_connect("MySystem","MyUserID","MyPasswd"); $result = odbc_exec($link,"select * from MySchema.MyTable"); $count = 0; while ($val= odbc_fetch_array($result)) { var_dump($val); $count++; } odbc_close($link); print "locale is :/n"; system('locale'); ?> Expected result: ---------------- Just return the CHAR string without extra data at the end. For example: array(1) { ["AFIELD"]=> string(6) "ü " } Actual result: -------------- array(1) { ["AFIELD"]=> string(40) "ü <bunch of garbage here as well as NULLs>" } -- Edit bug report at http://bugs.php.net/?id=47133&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=47133&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=47133&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=47133&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=47133&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=47133&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=47133&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=47133&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=47133&r=needscript Try newer version: http://bugs.php.net/fix.php?id=47133&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=47133&r=support Expected behavior: http://bugs.php.net/fix.php?id=47133&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=47133&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=47133&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=47133&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47133&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=47133&r=dst IIS Stability: http://bugs.php.net/fix.php?id=47133&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=47133&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=47133&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=47133&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=47133&r=mysqlcfg
