ID: 26012
Updated by: sniper@php.net
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:
Bug #25777 was fixed in 4.3.4RC2..
Previous Comments:
------------------------------------------------------------------------
[2003-10-28 11:21:34] boccara at netvision dot net dot il
when you write previously you mean previous this version ??
because in the 4.3.4 RC1 it works !
------------------------------------------------------------------------
[2003-10-28 10:59:08] iliaa@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
Previously mssql data was always rtrimed, however that's wrong because
it modifies the original data. This caused a problem for people who
needed those trailing space. Ultimately, the job of database extension
is to fetch the data as is (like other db extensions already do) and
not to mangle it in any way.
------------------------------------------------------------------------
[2003-10-28 10:52:12] boccara at netvision dot net dot il
it's possible ( I didn't check because there is a lot of data).
anyway I used in my request RTRIM to prevent any unwanted space.
note that this bug is really NEW to the actual version
------------------------------------------------------------------------
[2003-10-28 10:42:04] iliaa@php.net
Is there a space in the actual SQL data inside the db?
------------------------------------------------------------------------
[2003-10-27 17:05:43] boccara at netvision dot net dot il
Description:
------------
I have upgraded from 4.3.4 RC1
my program works already about 6 month with the latest version of php.
the probleme is that the fetch of an sql query return additonal non
breaking space as result.
this bug is absolutly new, I search in my code hours, and I returned to
the 4.3.4 RC1 and everything is Ok now.
Reproduce code:
---------------
Function dbFetch ($iResult, &$tabColonne) {
$iNbCol = 0;
$tabColonne = array();
switch (SGBD) {
case "MSSQL":
$tabColonne = mssql_fetch_array($iResult);
if($tabColonne)
{
$iNbCol = count($tabColonne);
}
break;
}
return $iNbCol;
}
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26012&edit=1