ID: 26315 Comment by: jwhatcher at hotmail dot com Reported By: webmaster at cbre dot fr Status: Bogus Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.3.4 New Comment:
'' = ' '. Politely, this is a bug. In transact sql and query analyzer '' is seen as '' but in php '' is seen as ' '. I am using varchar fields. This surely breaks several lines of code for the empty function is now useless when selecting '' out of the database. Please reconsider and look into this item. Add autotrim to the ini file if this would fix the problem. Previous Comments: ------------------------------------------------------------------------ [2004-06-20 02:49:52] spam2 at rhsoft dot net hmm this is a bug i developed a cms first for mysql and the port for postgre with select database-type works very fine the last two days i try to get it running with mssql/msde an nothing works with this damned spaces if (!empty($image)) echo "<img src=\"" . $image . "\" />"; for example makes a big shit :-( ------------------------------------------------------------------------ [2004-05-24 21:23:07] hagen at woecht dot de If you must make from a space to '' in your PHP script, how can you distinguish between a "true" space or "faked" space? All '' and space in the DB are then '' (:-((() ------------------------------------------------------------------------ [2004-04-23 10:25:51] tomasz at biznespolska dot pl In my opinion this is bug, and is still present on version 4.3.6. This is not only problem with CHAR, and NCHAR columns but also empty VARCHAR columns returns space. Example: $re = mssql_fetch_row(mssql_query("SELECT CAST('' AS VARCHAR(10))")); print('--'.$re[0].'--'); // the result is: -- -- // and should be: ---- Because of that I still use PHP4.3.3. ------------------------------------------------------------------------ [2004-03-24 04:33:03] francois dot zietlow at ri-solution dot com The Protocol have been changed. Quote from Sybase Doco. [quote] The empty string ("") is treated as a single space. In *char* and *nchar* *not null* columns, the result is a (column-length) field of spaces. [/quote] Found on Bug Report: http://bugs.php.net/bug.php?id=6527 Its not nice... Just I write my own empty-Function..... Francois ------------------------------------------------------------------------ [2004-03-24 04:18:11] francois dot zietlow at ri-solution dot com I think that is a Bug, too. I have the same Problem. It's not a solution to trim any value. Or?? @iliaa: Please write why do you think it's not a Bug. Thanks! Francois ------------------------------------------------------------------------ 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/26315 -- Edit this bug report at http://bugs.php.net/?id=26315&edit=1