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
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
49 + 21 = ?
Subscribe to this entry?

 
 [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-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 04:01:29 2024 UTC