freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
Nulls in Query Results using DBD-Sybase-0.94,
William, 10/23/2002
- <Possible follow-up(s)>
- Re: Nulls in Query Results using DBD-Sybase-0.94, Frediano Ziglio, 10/23/2002
- Re: Nulls in Query Results using DBD-Sybase-0.94, William, 10/23/2002
Archive powered by MHonArc 2.6.24.