Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: fetchrow_hashref issue
Date: Mar 29 2004 9:09PM

On Mon, 2004-03-29 at 12:55, Pickett, Mark J wrote:
> I'm having the same problem as Carl.  What's the news on whether
> DBD::Sybase can keep from outputting nulls on the ends of the strings?
> Solaris 9
> OpenClient 12.5.0
> Perl 5.8.0
> DBD::Sybase 1.02
> DBI 1.41
> Netcool 3.6 (based on Sybase 12.5.0)

Hmmm - this used to be a FreeTDS issue, AFAIK.

Can you show me an example where you have this problem?
Both the query, and the output result. Ideally run with DBI->trace(3) in
effect, please.


> From: "Bohman, Carl" 
> Subject: Re: fetchrow_hashref issue
> Date: Feb 26 2004 11:15PM
> Was the cause and/or solution to this problem ever figured out?  I'm
> definitely seeing null terminated strings as well and have been
> searching the net for a solution or workaround.  The null characters are
> present in all text fields and not in numeric fields.
> I'm using freetds 0.62.1, DBD::Sybase 1.02, and DBI 1.41 with Perl
> 5.8.2.  If it's relevant, I'm going up against Netcool Omnibus (a
> Sybase-like database from Micromuse).
> Carl
> From: Michael Peppler 
> Subject: Re: fetchrow_hashref issue
> Date: Nov 11 2003 12:31AM
> Looks like a problem with null-terminating strings (or not, as the case
> may be). I'll look at the DBD::Sybase code to see if there is something
> that I should be doing.
> Michael
Michael Peppler                              Data Migrations, Inc.             
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions -