#21662 [Opn->Fbk]: single data type not well returned

ID: 21662 Updated by: sniper@php.net Reported By: egarcia@egm.as -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.0 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [2003-01-15 09:21:48] egarcia@egm.as The function used to get the data is: $row = mssql_fetch_array($query_id); var_dump($row); Thanks in advance ------------------------------------------------------------------------ [2003-01-15 09:06:17] egarcia@egm.as In the PHP 4.3.0 exists a bug with the MSSQL single datatype, in the follow var_dump, you can see the PUNTAJE field. array(6) { [0]=> string(7) "3422864" ["ID"]=> string(7) "3422864" [1]=> string(20) "3.2051283432282E-306" ["PUNTAJE"]=> string(20) "3.2051283432282E-306" [2]=> string(10) "7725000.00" ["ADJUDICADO"]=> string(10) "7725000.00" } But in PHP 4.2.3 the bug doesn't exists, like you can see: array(6) { [0]=> string(7) "3422864" ["ID"]=> string(7) "3422864" [1]=> string(7) "175.652" ["PUNTAJE"]=> string(7) "175.652" [2]=> string(10) "7725000.00" ["ADJUDICADO"]=> string(10) "7725000.00" } The MSSQL fields data type are: ID = int PUNTAJE = single ADJUDICADO = money The PHP.ini is the same for both versions, the only change is the PHP version with its extensions. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=21662&edit=1