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

ID: 21662 Updated by: fmk@php.net Reported By: egarcia@egm.as -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.1.1 New Comment: This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2003-01-16 08:09:31] egarcia@egm.as Acord to your sugestion I use the last php4 stable win version (January 16, 2003, 8:35:37 AM) I get the original error and many errors more, please tell me how can I help. array(12) { [0]=> string(7) "3422864" ["ID"]=> string(7) "3422864" [1]=> float(2.2791297027772E-304) ["PUNTAJE"]=> float(2.2791297027772E-304) [2]=> string(10) "7725000.00" ["ADJUDICADO"]=> string(10) "7725000.00" } PHP has encountered an Access Violation at 00BB1493. ------------------------------------------------------------------------ [2003-01-15 09:33:47] sniper@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-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