#39204 [NEW]: MsSq_Fetch_* return Empty (Var)Char as single space

From: bertrand dot lepoittevin at groupe-mma dot fr Operating system: Windows 2000 PHP version: 4.4.4 PHP Bug Type: MSSQL related Bug description: MsSq_Fetch_* return Empty (Var)Char as single space Description: ------------ Hi, When reading Sql Char or Varchar Values which are empty (""), mssql_fetch_* functions returns a single space, instead of returning empty string. According to me this is a bug, right trimming values is just a workaround, and make thing more complicated when we need to compare values (form) and sql values. I know there is old issues of this problem (since PHP v4.3.4), but : - Is it really a ntwdblib.dll bug ? And which V° of this file corrects the MS bug ? - It it possible to avoid this pb in MSSQL APIs ? Ref : Sql server 8.0, ntwdblib.dll V2000.80.194.0 Regards. -- Edit bug report at http://bugs.php.net/?id=39204&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39204&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39204&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39204&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39204&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39204&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39204&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=39204&r=needscript Try newer version: http://bugs.php.net/fix.php?id=39204&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39204&r=support Expected behavior: http://bugs.php.net/fix.php?id=39204&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39204&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39204&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39204&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39204&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39204&r=dst IIS Stability: http://bugs.php.net/fix.php?id=39204&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39204&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39204&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39204&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=39204&r=mysqlcfg