Hi there,

Reposted from somewhere else:

-------------
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


-Jaimy

-------------------------------- 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(12345678);
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]."<br>";
}
ibase_close($dbh);

?>
---------


By the way, thanks for such a great product as PHP!

Best Regards,

Jorge Alvarez