#21662 [Opn]: single data type not well returned
| From: | egarcia at egm dot as | Date: | Wed, 15 Jan 2003 15:21:49 +0000 |
| Subject: | #21662 [Opn]: single data type not well returned | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-30123@lists.php.net to get a copy of this message | ||
ID: 21662
User updated by: egarcia@egm.as
Reported By: egarcia@egm.as
Status: Open
Bug Type: MSSQL related
Operating System: Windows 2000
PHP Version: 4.3.0
New Comment:
The function used to get the data is:
$row = mssql_fetch_array($query_id);
var_dump($row);
Thanks in advance
Previous Comments:
------------------------------------------------------------------------
[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