php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
 [2006-11-13 14:26 UTC] charlesk at netgaintechnology dot com 
Description:
------------
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

Patches

Pull Requests

History

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] fmk@php.net 
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-2025 The PHP Group
All rights reserved. 		Last updated: Fri Oct 31 19:00:02 2025 UTC