#40607 [NEW]: mssql_fetch_array concatinates spaces in middle of data

From: Joe at sofusion dot com Operating system: FREE BSD 6.0 PHP version: 5.2.1 PHP Bug Type: MSSQL related Bug description: mssql_fetch_array concatinates spaces in middle of data Description: ------------ When using mssql_fetch_arry and mssql_fetch_row, data returned that contains 2 spaces has been concatinated to one space. Example: Data returned should be "Two"' '' '"Spaces" (without quotes Two Spaces) But is returned as "Two"' '"Spaces" (without quotes -Two Spaces with one space between) FreeBSD WEBSERVER1.SOFUSION.local 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov 3 09:36:13 UTC 2005 root@x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386 Build Date Feb 22 2007 19:36:38 Configure Command './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--enable-versioning' '--with-mssql=/usr/local' '--enable-libxml' Library version FreeTDS Reproduce code: --------------- --MSSQL TABLE CREATE TABLE #T1( Name varchar(255), Number int ) INSERT INTO #T1 VALUES('Two Spaces',1) INSERT INTO #T1 VALUES('One Spaces',2) --PHP CODE $sql = "select Name FROM Name_TBL WHERE Number = '1'"; $rs = mssql_query($sql); $RT = mssql_fetch_array($rs); $Name= $RT[Name']; --This should have 2 spaces in it like the DB --But it only has one echo $Name Expected result: ---------------- Two Spaces --This has 2 spaces between the words. Actual result: -------------- Two Spaces --This only hase 1 space between the words -- Edit bug report at http://bugs.php.net/?id=40607&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40607&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40607&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40607&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=40607&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=40607&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=40607&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=40607&r=needscript Try newer version: http://bugs.php.net/fix.php?id=40607&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=40607&r=support Expected behavior: http://bugs.php.net/fix.php?id=40607&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=40607&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=40607&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=40607&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40607&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=40607&r=dst IIS Stability: http://bugs.php.net/fix.php?id=40607&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=40607&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=40607&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=40607&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=40607&r=mysqlcfg