Numeric type returns invalid result using
ibase_fetch_row/ibase_fetch_object (Windows NT).

Numbers stored as an InterBase/Firebird numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), do not return a float
type but cause an overflow 

Example:
2303511415 (decimal 10,0) returns -1991455881

PHP/Firebird example script:
$sql = "create table temp (large_number numeric(10,0))";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();


$sql = "INSERT INTO temp VALUES (2303511415)";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

$sql = "SELECT large_number FROM temp WHERE large_number = 2303511415";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}

while ($row = ibase_fetch_row($result)) {
   print($row[0]); 
}

ibase_free_result($result);

$sql = "drop table temp";
$result = ibase_query($sql,connection()); 
if (!$result) {
  exit;
}
ibase_commit();

Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip

No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

The problem still exits after downloadning the latest PHP4 at http://snaps.php.net/win32/php4-win32-latest.zip.

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

I've tried the CVS snapshot for Windows:

  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an overflow.


integer overflow is still there.

Fixed in current CVS and php_4_3

I've tried current CVS and php_4_3 for Windows.

Unfortunately the numeric/decimal datatype beyond
the bounds of the PHP integer type (> 2147483647), still causes an overflow.

Example:
InterBase 2303511415 (decimal 10,0) returns 2147483647

Make sure that you REALLY updated to the latest STABLE snaphot and ALL the dlls. (and you might need to reboot even)
(don't install anything when your webserver is running)

I've downloaded og installed the latest STABLE snaphot with ALL the dlls. After rebooting, the same erroneous number is returned from Interbase to PHP:

IB/Firebird datatype (decimal 10,0), value 2303511415 returns 2147483647.

Fixed both in CVS and php_4_3.

http://snaps.php.net/
please, try using Stable(4.3.x-dev) build >= 15 May

If it's fixed -> closed.