Re: Re: [PHP-DEV] PHP 4.0 Bug #3889 Updated: sybase_fetch_array returns a single space instead of empty strings

----- Original Message ----- From: Dean Bennett <dean.bennett@home.com> Sent: Wednesday, July 26, 2000 5:42:26 PM To: Bug Database <php-dev@lists.php.net> Subject: Re: [PHP-DEV] PHP 4.0 Bug #3889 Updated: sybase_fetch_array returns a single space instead of empty strings > This is probably a Sybase issue - it returns a space for non-NULL fields, even > if they were inserted as empty strings. I just had to deal with this today at > work. > > 1> create table test (name varchar(15) null) > 2> go > 1> insert test values ("") > 2> go > (1 row affected) > 1> insert test values (NULL) > 2> go > (1 row affected) > 1> select * from test > 2> go > name > --------------- > > NULL > > (2 rows affected) > 1> select 'x'+name+'x' from test > 2> go > > ----------------- > x x > xx > > (2 rows affected) > > See that the empty row has a space, the NULL row has nothing. And this is right > out of isql, so I don't think that php can do any better. > Thanks for the info! - Zak