On Tue, 2003-03-25 at 01:50, [EMAIL PROTECTED] wrote: > Hi Michael > > >> The issue is that trailing whitespace has been truncated > >> from the last output. > > >> When the same SQL is run using isql, the output is as expected. > >> So, this appears to be an issue either with DBI or with DBD::Sybase. > > > This isn't DBI, and it isn't DBD::Sybase. The last query probably > > creates a work table, where "foo " is treated as a varchar, which causes > > the trailing whitespace to be removed. You could check this assumption > > by turning on showplan. > > Thanks for the suggestion. It sounds spot on in that, to quote from the > documentation:
> My confusion arises from the fact that the same SQL statement, > when run via isql, does not remove the trailing whitespace: > > SQL > ====================================== > select "*" + "foo " + "*" from master..sysengines > select "*" + "foo " + "*" order by 1 > select "*" + "foo " + "*" from master..sysengines order by 1 > go > ====================================== I just tried this exact code in DBD::Sybase, and got the exact same results as you did in isql... Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
