ID: 41399 User updated by: geniuz at geniuz dot cz Reported By: geniuz at geniuz dot cz Status: Open Bug Type: PDO related Operating System: XP PHP Version: 5.2.2 New Comment:
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...? Previous Comments: ------------------------------------------------------------------------ [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
