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: lost precision with money columns read from perl/sybperl
Date: Apr 3 2003 3:48PM

On Thu, 2003-04-03 at 01:01, d.desseaux@circo.fr wrote:
> Are you sure the bug N 261 "Money/Numeric potentially lose precision in
> Sybase::CTlib", which had been corrected in version 2.11, is not back ?
> 
> My data are stored on an AIX4.3.3, with Sybase at 12.0.4 level.
> 
> Clients use Sybperl/CTlib version 2.15, either on IBM-RS6000 servers
> (AIX4.3.3)
> with perl 5.00503 and/or Linux/Mandrake (2.4.19) with perl 5.8.0.
> 
> Installed sybperl version
> $ perl -M'Sybase::CTlib(999)'
> Sybase::CTlib version 999 required--this is only version 2.15 at
> /usr/lib/perl5/5.8.0/Exporter/Heavy.pm line 116.
> BEGIN failed--compilation aborted.

You are correct - the fix for 261 wasn't implemented correctly (or
completely).

The work-around for you *now* is to turn on the UseMoney attribute (at
some performance cost during fetches).

I'll try to post a patch ASAP.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html