Re: DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Terence J. Young, D.C.
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

Re: DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Rainer J. H. Brandt
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

DBD::Sybase returns blank character instead of empty string

2005-04-27 Thread Rainer J. H. Brandt
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