PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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.

Michael

> 
> 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.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.peppler.org/resume.html