Skip to Content.
Sympa Menu

freetds - Nulls in Query Results using DBD-Sybase-0.94

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "William" <w1234 AT prmail.net>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Nulls in Query Results using DBD-Sybase-0.94
  • Date: Wed, 23 Oct 2002 13:26:55 -0400


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;

and the output is:


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

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'

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





Archive powered by MHonArc 2.6.24.

Top of Page