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:
This fix makes fetching on char() columns work differently that it used to. MMSQL Server and other RDBMS's patches the data in a char() column with trailing spaces. When data are fetched with the new version of the extension these extra spaces are returned. A char() column is a fixed length datatype so the database adds extra spaces when the content is shortar than the defined length. Using a varchar() column is a way to avoid this problem. Previous Comments: ------------------------------------------------------------------------ [2003-10-28 11:45:36] [EMAIL PROTECTED] Bug #25777 was fixed in 4.3.4RC2.. ------------------------------------------------------------------------ [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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] Is there a space in the actual SQL data inside the db? ------------------------------------------------------------------------ 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
