|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #39497 Re 34096
Submitted: 2006-11-13 14:26 UTC Modified: 2007-04-04 15:46 UTC
From: charlesk at netgaintechnology dot com Assigned: fmk (profile)
Status: Wont fix Package: MSSQL related
PHP Version: 4.4.4 OS: Windows 2003 Standard
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: charlesk at netgaintechnology dot com
New email:
PHP Version: OS:


 [2006-11-13 14:26 UTC] charlesk at netgaintechnology dot com
php_mssql.dll from version 4.3.1 works without a problem.  php_mssql.dll from version 4.4.4 does not.  This is a change in PHP not in Microsoft.  How is this a Microsoft problem?  What changed in this DLL to make it not work?  My environment is set up that if I put the new version of the DLL in place, it starts throwing spaces everywhere.  If I put the 4.3.1 version dll back it stops throwing spaces everywhere.

Reproduce code:
Copy the new php_mssql.dll in place

Expected result:
Nulls and empty strings returned as nulls and empty strings.

Actual result:
nulls as nulls,  Empty strings as a single space


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2007-04-04 13:45 UTC] charlesk at netgaintechnology dot com
I am dissappointed,  I paid software would not go unanswered for 4 months.
 [2007-04-04 15:46 UTC]
There is a bug in the MSSQL library used for this extension.

In older versions we used to right trim the content of string values, but that gives problems when the value actualy has spaces at the end of thie string. It was decided to return the data as thery are provided by the library.

A fix for this problem is to use the php_dblib.dll version of the extension. This is created with the FreeTDS library (no microsoft components needed). Unfortunately this is only available in PHP 5.x versions.
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Mon Jun 14 00:01:24 2021 UTC