#32663 [Fbk->NoF]: odbc_fetch_row fails to get single selected MySQL text column

ID: 32663 Updated by: php-bugs@lists.php.net Reported By: mizmerize at yahoo dot com -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: Windows 2000 Advanced Server SP3 PHP Version: 5.0.4 New Comment: No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2005-04-11 17:57:36] sniper@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2005-04-11 03:27:52] mizmerize at yahoo dot com 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 this bug report at http://bugs.php.net/?id=32663&edit=1