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

ID: 23316 Updated by: fmk@php.net Reported By: hammer88 at hotmail dot com Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.2-RC New Comment: updating php.exe and php4ts.dll is not enough. all the mssql functions are located in php_mssql.dll. Previous Comments: ------------------------------------------------------------------------ [2003-04-30 19:39:30] 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-04-30 06:14:45] sniper@php.net Did changing the currency settings affect this or not? ------------------------------------------------------------------------ [2003-04-24 03:26:49] sniper@php.net try it? ------------------------------------------------------------------------ [2003-04-23 16:20:30] 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-23 11:02:01] 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 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/23316 -- Edit this bug report at http://bugs.php.net/?id=23316&edit=1