Hi,
Actually, when storing an empty string, '', to a varchar, sybase stores
it as a space.
Some apps provide a setting to strip trailing spaces.
terry
Rainer J. H. Brandt wrote:
Hi,
I have stored en empty string in a varchar(255) column of a Sybase ASE.
When I retrieve it via
$r = $dbh->selecta
Hello again,
I apologize for my previous email, which was both partially wrong
and also premature -- rtfm would have helped.
I had written:
> Notice: The Database really has an empty string, not a NULL value or any
> other weird thing.
And in fact, Sybase had really stored a string consisting
Hi,
I have stored en empty string in a varchar(255) column of a Sybase ASE.
When I retrieve it via
$r = $dbh->selectall_arrayref("select Value from Example where Id = 17");
then the following is true:
$r->[0]->[0] eq ' '
I expected it to be false and instead
$r->[0]->[0] eq ''
(with an