#23316 [NEW]: Loss of precision in float data when SQL Server is queried

From: hammer88 at hotmail dot com Operating system: Windows 2000 PHP version: 4.3.1 PHP Bug Type: MSSQL related Bug description: Loss of precision in float data when SQL Server is queried I created a query and tested in SQL Server Query Analyzer. The query returns a number that is stored as 1.0947 as data type money to 8 digits. But when I run this query from PHP $dbTradeRow=mssql_fetch_object($trades_result) to retrieve the data and check that column, it returns only 1.09 and i loose the last two digits. Can somebody please help me out? -- Edit bug report at http://bugs.php.net/?id=23316&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=23316&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=23316&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=23316&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=23316&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=23316&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=23316&r=support Expected behavior: http://bugs.php.net/fix.php?id=23316&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=23316&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=23316&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=23316&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23316&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=23316&r=dst IIS Stability: http://bugs.php.net/fix.php?id=23316&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=23316&r=gnused