php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #32663 odbc_fetch_row fails to get single selected MySQL text column
Submitted: 2005-04-11 03:27 UTC Modified: 2005-04-19 01:00 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: mizmerize at yahoo dot com Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 5.0.4 OS: Windows 2000 Advanced Server SP3
Private report: No CVE-ID: None
 [2005-04-11 03:27 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-04-11 17:57 UTC] 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-19 01:00 UTC] php-bugs at lists dot php dot net
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".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Dec 02 23:01:29 2024 UTC