From: mizmerize at yahoo dot com Operating system: Windows 2000 Advanced Server SP3 PHP version: 5.0.4 PHP Bug Type: ODBC related Bug description: odbc_fetch_row fails to get single selected MySQL text column
Description: ------------ I used ODBC Unified using a MyODBC driver version 3.51.11 and connected to a table with a varchar and a TEXT column. Then I created a query like this: $sql="SELECT Title FROM tbllibrarymaterials" .. the odbc_exec function does good. It provides a non-false result. but if I have to get the rows by using odbc_fetch_row, this function returns false and I could not get a record. But... If I defined another column along with the query: $sql="SELECT Title, Call_Number FROM tbllibrarymaterials" ...I get the expected results. [PHP.INI] odbc.longreadlen=65535 odbc.binmode=1 I set this because it may be the problem with long columns. But this settings did not change anything. Reproduce code: --------------- To reproduce the bug, you must create a table called "tbllibmaterials" (or any name) in MySQL with a varchar(50) for the Call_Number and TEXT column for the Title, and use odbc_fetch_row running the query: $sql="SELECT Title FROM tbllibrarymaterials" Expected result: ---------------- No records can be retrieved. Actual result: -------------- No records can be retrieved. -- Edit bug report at http://bugs.php.net/?id=32663&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32663&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32663&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32663&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32663&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32663&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32663&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32663&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32663&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32663&r=support Expected behavior: http://bugs.php.net/fix.php?id=32663&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32663&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32663&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32663&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32663&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32663&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32663&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32663&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32663&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32663&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32663&r=mysqlcfg
