ID:               37097
 Updated by:       [EMAIL PROTECTED]
 Reported By:      stochnagara at hotmail dot com
-Status:           Assigned
+Status:           Wont fix
 Bug Type:         PDO related
 Operating System: windows xp
 PHP Version:      5.1.3RC2
 Assigned To:      wez
 New Comment:

That's the stringified format that dblib returns to PDO.
We're not going to "fix" this; we asked for a string and that's the
string that is handed to us by dblib.

You should also note that dblib on windows is an unsupported legacy
library that has not shipped with SQL server for the last couple of
releases; unless you absolutely MUST use it, you are STRONGLY
recommended to use ODBC to connect to MSSQL.


Previous Comments:
------------------------------------------------------------------------

[2006-04-16 20:14:49] [EMAIL PROTECTED]

FYI: You should use PDO ODBC on Windows.


------------------------------------------------------------------------

[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

Reply via email to