#41399 [Asn->Fbk]: PDO don't read ODBC TEXT column

From: Date: Sat, 25 Apr 2009 14:45:10 +0000
Subject: #41399 [Asn->Fbk]: PDO don't read ODBC TEXT column
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-136257@lists.php.net to get a copy of this message 
 ID:               41399
 Updated by:       jani@php.net
 Reported By:      geniuz at geniuz dot cz
-Status:           Assigned
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: XP
 PHP Version:      5.2.2
 Assigned To:      wez
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/




Previous Comments:
------------------------------------------------------------------------

[2007-05-15 15:22:27] geniuz at geniuz dot cz

I found now that I can't call odbc_result function more than one time,
only first call return me data from TEXT type column.
So it is possible that PDO implements more than one call of odbc_result
for TEXT type columns...?

------------------------------------------------------------------------

[2007-05-15 14:28:12] geniuz at geniuz dot cz

Description:
------------
I have column type TEXT.
When I read it over odbc_result, it works fine.
When I read it over PDO, column is empty.
More, all next readed columns after this column are empty too.
For example: SELECT ID, CSN, Spec FROM MYTABLE
When CSN column type is TEXT, I obtain empty data for CSN a Spec
columns.
I have downloaded http://snaps.php.net/win32/php5.2-win32-latest.zip
before I send this bug.

Reproduce code:
---------------
if($sth = $pdo->query( "SELECT ID, CSN, Spec FROM MYTABLE" ))
{
	while( ($row = $sth->fetch(PDO::FETCH_NUM)) )
	{
		echo "ID:".$row[0]."<BR>";
		echo "CSN:".$row[1]."<BR>";
		echo "Spec:".$row[2]."<BR>";
	}
}


Expected result:
----------------
Not empty $row[1] and $row[2]

Actual result:
--------------
Empty $row[1] and $row[2]


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=41399&edit=1

Thread (4 messages)

« previous php.bugs (#136257) next »