From: butterfly110Pro at yahoo dot com Operating system: Windows 2003 Server R2 PHP version: 5.2.6 PHP Bug Type: MSSQL related Bug description: Retrieved Floating Point Numbers From Float Column in MSSQL Appeares Different
Description: ------------ Salam, When I Retrieving A Data From SQL Server With a Column that its Column Type in SQL Server is Float, I See That Two Type of Numbers Shows, 1. Integer Or Floating Numbers With its Real Writing Style (e.g. 1200001, 1.200001) 1. Integer (This is What Happened For Me!) Numbers With Scientific Writing Style (e.g. 1200000 appeares 1.2E+6, 1400000 appeares 1.4E+6) Fantastic Top That is This Appearance Diferrences Only Happens for (12 With More Than 5 Zeros, and 14 With More than 5 Zeros, I Try This For 1199999 and 1200001 But The Happen Didn't Happen!) Reproduce code: --------------- Select * From ATable Expected result: ---------------- array( 0 => array( FirstFloatColumn => 1199999, SecondFloatColumn => 1200000, ThirdFloatColumn => 1200001, FourthFloatColumn => 1399999, FifthFloatColumn => 1400000, SixthFloatColumn => 1400001, SeventhfFloatColumn => 1100000, EightthFloatColumn => 1300000, NinethFloatColumn => 1500000, TenthFloatColumn => 1600000, EleventhFloatColumn => 11999999, TwelvethFloatColumn => 12000000, ThirteenthFloatColumn => 12000001, FourteenthFloatColumn => 13999999, FifteenthFloatColumn => 14000000, SixteenthFloatColumn => 14000001, ) ) Actual result: -------------- array( 0 => array( FirstFloatColumn => 1199999, SecondFloatColumn => 1.2E+6, ThirdFloatColumn => 1200001, FourthFloatColumn => 1399999, FifthFloatColumn => 1.4E+6, SixthFloatColumn => 1400001, SeventhfFloatColumn => 1100000, EightthFloatColumn => 1300000, NinethFloatColumn => 1500000, TenthFloatColumn => 1600000, EleventhFloatColumn => 11999999, TwelvethFloatColumn => 1.2E+7, ThirteenthFloatColumn => 12000001, FourteenthFloatColumn => 13999999, FifteenthFloatColumn => 1.4E+7, SixteenthFloatColumn => 14000001, ) ) -- Edit bug report at http://bugs.php.net/?id=46232&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=46232&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=46232&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=46232&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=46232&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=46232&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=46232&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=46232&r=needscript Try newer version: http://bugs.php.net/fix.php?id=46232&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=46232&r=support Expected behavior: http://bugs.php.net/fix.php?id=46232&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=46232&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=46232&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=46232&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46232&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=46232&r=dst IIS Stability: http://bugs.php.net/fix.php?id=46232&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=46232&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=46232&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=46232&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=46232&r=mysqlcfg
