Re: Re: [PHP-DEV] PHP 4.0 Bug #3889 Updated: sybase_fetch_array returns a single space instead of empty strings From: zak <email protected>
Date: 07/26/00

----- Original Message -----
From: Dean Bennett <dean.bennett <email protected>>
Sent: Wednesday, July 26, 2000 5:42:26 PM
To: Bug Database <php-dev <email protected>>
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 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>