The following bug report was posted to an InterBase newsgroup:
-----------
Anyone who are using PHP + Interbase should be aware of this bugs especially
when trying to retrieve IB decimal/float data type from a stored
procedure(s). I have reproduced this error that seems as a bug on PHP when
retrieving data from ib that could be found in the attached file.
i tried to execute this query from IBConsole:
SELECT * FROM TEST_P;
and the result is:
94000581000
85000587000
27058581000
12334547000
12345678000
while PHP shows:
-488699512.21
-898758920.19
1288777224.6
-550354888.2
-539223888.2
-------------------------------- TEST.SQL -----------------------
create table test
tbvalue decimal(18,3)
);
commit work;
insert into test values(94000581);
insert into test values(85000587);
insert into test values(27058581);
insert into test values(12334547);
insert into test values(1234567;
commit work;
set term ^;
create procedure test_p
returns
spvalue decimal(18,3)
) as
begin
for select tbValue from test into :spvalue do
begin
spvalue = spvalue * 1000;
suspend;
end
end
^
set term ;^
commit work;
------- TEST.PHP -----------------
$dbh = ibase_connect("datacenter:d:/currdata/test.gdb","sysdba","xxxxxxx");
$sql_stat = "select spvalue from test_p;";
$ibqry= ibase_query($dbh, $sql_stat);
while ($row = ibase_fetch_row($ibqry))
print $row[0]."
";
}
ibase_close($dbh);
?>
-----------
I've confirmed this on a Windows platform using Apache, PHP 4.05 and
Interbase 6.01, however the person reporting this confirmed that the bug is
not present in a Linux environment.
Any insight is appreciated.
Regards,
-Jorge
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
