#37097 [Opn->Asn]: PDO-MSSQL converts bigint to float.

ID: 37097 Updated by: tony2001@php.net Reported By: stochnagara at hotmail dot com -Status: Open +Status: Assigned Bug Type: PDO related Operating System: windows xp PHP Version: 5.1.3RC2 -Assigned To: +Assigned To: wez New Comment: Assigned to the maintainer. Previous Comments: ------------------------------------------------------------------------ [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