ID: 37097
Updated by: [EMAIL PROTECTED]
Reported By: stochnagara at hotmail dot com
Status: Assigned
Bug Type: PDO related
Operating System: windows xp
PHP Version: 5.1.3RC2
Assigned To: wez
New Comment:
FYI: You should use PDO ODBC on Windows.
Previous Comments:
------------------------------------------------------------------------
[2006-04-16 07:57:49] [EMAIL PROTECTED]
Assigned to the maintainer.
------------------------------------------------------------------------
[2006-04-16 07:44:32] stochnagara at hotmail dot com
Description:
------------
PDO MsSql driver returns bigint values as float instead of int.
They are always formated as <number>.0
Reproduce code:
---------------
CREATE TABLE demo (
bi bigint not null,
sm int null
);
insert into demo (1,1);
$result = $pdo->query ("SELECT * FROM demo")->fetch();
echo "bi={$result['bi']};"
echo "sm={$result['sm']};"
Expected result:
----------------
bi=1;sm=1;
Actual result:
--------------
bi=1.0;sm=1;
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37097&edit=1