Hello everyone,

I'm using Perl 5.6.1, DBI-1.30, DBD-Sybase-0.94, Nightly Snapshot of FreeTDS, RH 7.3.

In perl I do:

$rows = $sth->dump_results;
[download]

and the output is:

DBI:Sybase:database=staff
SELECT NAME FROM STAFF
'Admin............................'
'JAlvarez.........................'
'Rosa.rez.........................'
3 rows
[download]

The column NAME in STAFF is defined as VARCHAR(40)

The values returned from the query all have a null character attached to the end of the field value plus extra characters from the previous row.

I was expecting:

'Admin'
'JAlvarez'
'Rosa'
[download]

To get what I expected I clean up the query results by stripping everything after the first null.

The same query with Perl 5.6.0, DBI-1.16, DBD-Sybase-0.91, Nightly Snapshot of FreeTDS-0.52, RH 7.1 worked as expected.

Why are my query results different with the new versions?

Thanks in advance,

William