#46981 [Opn->Fbk]: PDO get Data Bug for Firebird DBMS

From: Date: Thu, 01 Jan 2009 01:59:16 +0000
Subject: #46981 [Opn->Fbk]: PDO get Data Bug for Firebird DBMS
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-132470@lists.php.net to get a copy of this message 
 ID:               46981
 Updated by:       kalle@php.net
 Reported By:      flylink at 126 dot com
-Status:           Open
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: Windows
 PHP Version:      5.2.8
 New Comment:

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.





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

[2008-12-31 03:16:01] flylink at 126 dot com

Description:
------------
I use PDO driver to access Firebird DBMS,
find a bug,I couldn't get first row's data

Reproduce code:
---------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>PDO for Firebird</title>
</head>

<body>

<?php
 $host='localhost';
 $dbname='newsite';
 $user='SYSDBA';
 $pass='masterkey';
 $dsn="firebird:dbname=$dbname;host=$host;charset=NONE";
 $dbConn= new PDO($dsn, $user, $pass);

 print "<br />PDO BUG for Firebird:<br />";
 $sql='SELECT * from link';
 $rs=$dbConn->query($sql); 
 foreach ($rs as $row) {  print "1==>".$row[1]."
2==>".$row['SITELINK']."<br />";  }
 
 $dbConn=NULL; 
?>

</body>
</html>

Expected result:
----------------
PDO BUG for Firebird:
1==>Firebird 2==>http://www.firebirdsql.org
1==>?̐򔱃SDN 2==>http://www.csdn.net
1==>???í¼¾ 2==>http://firebird.dearinfo.com/
1==>IBPhoenix 2==>http://www.ibphoenix.com
1==>??Ô½PHP 2==>http://www.phpe.net
1==>Fracle-Janus Soft 2==>http://www.janus-software.com
1==>Firebird֐΄ɧǸ 2==>http://www.firebird.net.cn
1==>?㖝ʀ?͈?Ї׊Ѷ 2==>http://www.it136.net
1==>DelphiÔ°?Ø 2==>http://www.delphifans.com
1==>Delphi K.TopӑՓ?^ 2==>http://delphi.ktop.com.tw
1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/
1==>Firebird?ٷ?͸վ 2==>http://www.firebirdsql.org/
1==>Β?IJ??͠2==>http://blog.csdn.net/jianlei/
1==>DelphiÒ¤?? 2==>http://www.51delphi.com
1==>Delphi?ЗӠ2==>http://www.2ccc.com
1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm
1==>???UŌ 2==>http://jianlei.ys168.com


Actual result:
--------------
PDO BUG for Firebird:
1==> 2==>
1==>?̐򔱃SDN 2==>http://www.csdn.net
1==>???í¼¾ 2==>http://firebird.dearinfo.com/
1==>IBPhoenix 2==>http://www.ibphoenix.com
1==>??Ô½PHP 2==>http://www.phpe.net
1==>Fracle-Janus Soft 2==>http://www.janus-software.com
1==>Firebird֐΄ɧǸ 2==>http://www.firebird.net.cn
1==>?㖝ʀ?͈?Ї׊Ѷ 2==>http://www.it136.net
1==>DelphiÔ°?Ø 2==>http://www.delphifans.com
1==>Delphi K.TopӑՓ?^ 2==>http://delphi.ktop.com.tw
1==>DotNetFirebird 2==>http://www.dotnetfirebird.org/
1==>Firebird?ٷ?͸վ 2==>http://www.firebirdsql.org/
1==>Β?IJ??͠2==>http://blog.csdn.net/jianlei/
1==>DelphiÒ¤?? 2==>http://www.51delphi.com
1==>Delphi?ЗӠ2==>http://www.2ccc.com
1==>??͸ҳ 2==>http://www.destructor.de/firebird/index.htm
1==>???UŌ 2==>http://jianlei.ys168.com



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


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

Thread (6 messages)

« previous php.bugs (#132470) next »