#33154 [NEW]: MSSQL fetches for smallmoney and money fields create large numeric strings

From: jroyer at omegafi dot com Operating system: Red Hat ES 4 PHP version: 5.0.4 PHP Bug Type: MSSQL related Bug description: MSSQL fetches for smallmoney and money fields create large numeric strings Description: ------------ We are using PHP 5.0.4/Apache 2.0.54 with FreeTDS 0.63 against a SQL Server 2000 server. When fetching money or smallmoney fields from the database, the return value is a string of size 28 or 24 respectively. This problem has surfaced when upgrading our web servers from 4.3.2 to 5.0.4. Version 4.3.2 behaves as expected. I have used the php.ini-dist out of the box to produce this problem. The configure line is as follows: ./configure \ --with-apxs2=/usr/local/apache/bin/apxs \ --enable-bcmath \ --enable-wddx \ --with-config-file-path=/etc/php4/cgi \ --with-xml \ --with-zlib \ --enable-memory-limit \ --with-sybase=/usr/local/freetds \ --enable-magic-quotes=yes \ --enable-force-cgi-redirect \ --with-gd \ --enable-gd-native-ttf \ --with-zlib-dir=/usr/include \ --with-jpeg-dir=/usr \ --with-png-dir=/usr \ --with-cpdflib=/usr/local \ --with-ttf=/usr \ --with-mysql=/usr/include/mysql \ --with-freetype_dir=/usr/include/freetype2 Reproduce code: --------------- mssql_connect("Server", "UserName","Password"); mssql_select_db("Database"); $sql="Select SmallMoneyField from Table"; $result = mssql_query($sql); $row = mssql_fetch_array($result); while ($row = mssql_fetch_array($result)) { $data[] .= $row["SmallMoneyField"]; echo $row["TransactionAmount"]; } echo strlen($ydata[1]) . '<br>'; Expected result: ---------------- When the code is executed I expect to see a return of a money field with a string length equalling the number of digits (ex. "5.00" should be string length of 4). Output of the string, when viewing the browser source, shows a number followed by spaces. Actual result: -------------- For money fields I get a string length of 28, regardless of the actual number length and a string length of 24 for smallmoney fields. Other fields, such as text, varchar and integers behave as expected with values matching the number of digits/characters. -- Edit bug report at http://bugs.php.net/?id=33154&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33154&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33154&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33154&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33154&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33154&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33154&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33154&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33154&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33154&r=support Expected behavior: http://bugs.php.net/fix.php?id=33154&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33154&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33154&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33154&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33154&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33154&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33154&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33154&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33154&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33154&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33154&r=mysqlcfg