Re: 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. Bug Database wrote: > > ID: 3889 > Updated by: zak > Reported By: k@les.cz > Status: Feedback > Bug Type: Sybase-ct (ctlib) related > Assigned To: > Comments: > > Has any progress been made on this bug report? > > Full Bug description available at: http://bugs.php.net/?id=3889 > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net