#23316 [Opn->Fbk]: Loss of precision in float data when SQL Server is queried

ID: 23316 Updated by: sniper@php.net Reported By: hammer88 at hotmail dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.1 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-04-23 10:06:11] hammer88 at hotmail dot com 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 this bug report at http://bugs.php.net/?id=23316&edit=1