php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #23316 Loss of precision in float data when SQL Server is queried
Submitted: 2003-04-23 10:06 UTC Modified: 2003-05-20 18:42 UTC
From: hammer88 at hotmail dot com Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.3.2-RC OS: Windows 2000
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: hammer88 at hotmail dot com
New email:
PHP Version: OS:

 

 [2003-04-23 10:06 UTC] 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?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-23 11:02 UTC] sniper@php.net 
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
 [2003-04-23 16:20 UTC] hammer88 at hotmail dot com 
Replaced the php.exe & php4ts.dll files and verified the new version with phpinfo().  But problem still persisted.  Is this because php utilizes the local computer's currency settings?  Which I assume default for Windows is two decimal places?  That wouldn't be cool to have to change that default just for this instance... ideas?
 [2003-04-24 03:26 UTC] sniper@php.net 
try it?
 [2003-04-30 06:14 UTC] sniper@php.net 
Did changing the currency settings affect this or not?
 [2003-04-30 19:39 UTC] hammer88 at hotmail dot com 
I did not try modifying the locale format.  My solution was just modifying the data type in SQL Server so it was a decimal instead of money.  All is well.
 [2003-05-20 18:21 UTC] fmk@php.net 
updating php.exe and php4ts.dll is not enough. all the mssql functions are located in php_mssql.dll.
 [2003-05-20 18:42 UTC] fmk@php.net 
MSSQL server will return 2 digits after the decimal point for money and small money solumns.

You can use the convert() function to increase this to 4 digits.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 11:01:30 2024 UTC