ID: 26012
Updated by: [EMAIL PROTECTED]
Reported By: boccara at netvision dot net dot il
Status: Bogus
Bug Type: MSSQL related
Operating System: win2k SBS SP4 & Apache 2.0.47
PHP Version: 4.3.4RC2
New Comment:
I have tried to get Microsoft to updet the library for years but DBLIB
was discontinued and might not be supported in new versions of the SQL
Server! We are still using the LIBS from SQL Server 6.0.
I think the best fix would be to get FreeTDS to work under Win32, and
I'm working on that. I don't like the idea of adding ini settings to
get arround bugs. You could write a small wrapper function that does
this for you if you need it, but I don't see a way to make a working
fix as it would make 'a ' become 'a' and that would be wring if you
insertd 'a ' into the database.
Previous Comments:
------------------------------------------------------------------------
[2003-11-20 12:10:08] jro at aucotec dot com
what do you think about an ini-switch like "auto rtim, auto ltrim, auto
ltrim and auto rtrim" to solve this problem for the future?
------------------------------------------------------------------------
[2003-11-20 12:04:08] jro at aucotec dot com
--- Zitat
The code was changed to fix a bug (#25777). This causes an other
problem as there is a bug in the mssql library we use to build the
extension. It has not been possible to get an updated version of this
library from Microsoft
--- Zitat ende
Do you have an Statement of Microsoft for this Bug?
In my Application i'm testing for a value of null and for a blank value
(like ''). Its a problem when i'm getting an value of ascii code 32
wich is a space.
why it has not been possible to get an updated version of this library
from Microsoft?
------------------------------------------------------------------------
[2003-10-29 14:34:07] [EMAIL PROTECTED]
The code was changed to fix a bug (#25777). This causes an other
problem as there is a bug in the mssql library we use to build the
extension. It has not been possible to gen an updated version of this
library from Microsoft.
Your code seamed to work fine with older versions of the extension, as
all char and varchar fields was trimmed for trailing spaces. This is no
longer the case and the fact that the library returns a single space
when the column is empty and when the column contains a single space is
not a problem with the php extension.
For older versions of the extension it was not possible to store a
value with spaces at the end, these would be trimmed out by the
extension.
The way the extension works now is the correct way (data is passed on
from the database to the user ast it is).
------------------------------------------------------------------------
[2003-10-29 03:08:16] boccara at netvision dot net dot il
I agree with you, but why I only have this problem with the 4.3.4RC2
version ???????
I remind you that it works with 4.3.4RC1 and older version !
------------------------------------------------------------------------
[2003-10-28 17:32:14] [EMAIL PROTECTED]
The C API provided from Microsoft is the problem in this cse. An ampty
column is returned as a single space and not as a true empty column (a
string with length 0). It is not possible to see the difference between
an empty column and a column with a single space.
In this case it is a bug, but not in PHP! As stated before the PHP
extensions sould not attempt to 'fix' data but just present them as is.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/26012
--
Edit this bug report at http://bugs.php.net/?id=26012&edit=1
