[freetds] trailing spaces

Dan Wierenga dan at hornytoad.com
Wed May 26 16:32:46 EDT 2004



Lowden, James K wrote:

  > The DBI documentation says that a driver may implement the ChopBlanks 
statement handle attribute, and that if it doesn't, it should return undef.
> 
> AFAICT, DBD::Sybase doesn't do either of those things.  You can set the attribute, but it has no effect.  That is,
> 
> 	$sth = $dbh->prepare($query);
> 	print $sth->{"ChopBlanks"} = 1;

That works great, actually.  Thanks!

Different versions of Perl/DBI/DBD::Sybase perhaps?


> doesn't alter whether or not the elements in the list returned by $sth->fetchrow are trimmed.  
> 
> However, DBD::Sybase treats char and varchar differently, in the expected way: char columns are blank padded; varchar are not.

At least on my version, both varchar and char are blank-padded.

Thanks for the help,
Dan

-- 
Dan Wierenga
IT Manager
HornyToad Inc.
mailto:dan at hornytoad.com



More information about the FreeTDS mailing list