#22352 [Opn->Bgs]: Numeric Sybase Problem

ID: 22352 Updated by: iliaa@php.net Reported By: c dot villemagne at circo dot fr -Status: Open +Status: Bogus Bug Type: Sybase (dblib) related Operating System: Linux Mandrake 9.0 PHP Version: 4.3.0 New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php NUMERIC fields are treated as doubles, since they could possibily overflow PHP's long, which are limited to a 32 bit number of 32 bit systems and 64 bit number on 64 bit systems. If you want the result to be an integer make sure that field is defined as an integer. Previous Comments: ------------------------------------------------------------------------ [2003-02-25 01:34:45] c dot villemagne at circo dot fr The field is a numeric ! The summary of this bug is : "numeric sybase Problem" ! ------------------------------------------------------------------------ [2003-02-24 22:28:23] iliaa@php.net What are the fields in the test_numeric table defined as? ------------------------------------------------------------------------ [2003-02-24 02:49:16] c dot villemagne at circo dot fr I used the cvs snapshot http://snaps.php.net/php4-STABLE-latest.tar.gz but the problem is the same. I have always 100.0, 200.0 or not 100,200 Are you a other solution ? ------------------------------------------------------------------------ [2003-02-22 11:52:19] iliaa@php.net 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 ------------------------------------------------------------------------ [2003-02-21 06:29:33] c dot villemagne at circo dot fr $id=sybase_query ( "select * from test_numeric", $sybcon); while ( $row = sybase_fetch_row($id) ) { echo "<tr><td>$row[0]</td></tr>\n"; } $row[0] receive value 100.0,200.0 or not 100,200. Why ? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22352&edit=1