php.net |  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: charlesk at netgaintechnology dot com
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2020 The PHP Group
All rights reserved.
Last updated: Tue Dec 01 18:01:23 2020 UTC