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