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: mpeppler at itf dot ch (Michael Peppler)
Subject: Re: large integers
Date: Jan 31 1996 9:28AM

I wrote:
> From: ivan@algorithmics.com (Ivan Simon)
> > I am having trouble with sybase returning large (16 or more
> > digits) identity numbers to perl. I am looking for a way to
> > handle the identity numbers as strings from the perl/sybperl
> > side.
> 
> I guess there are two solutions: Sybperl could test the size of the
> NUMERIC variable, and convert to char (using dbconvert()) if the
> precision is >= 16. Alternatively, we could force the conversion of
> NUMERIC data to char using a special flag (like the dbKeepNumeric
> flag), and this would avoid the problems.

Actually, the problem is that you need to enable the System 10 features
in DBlibrary, otherwise numeric/decimal/identity data is returned as
FLOAT...

Sybperl has dbsetversion(), but I just found out that it doesn't
work...

So I'm going to call 
	dbsetversion(DBVERSION_100)
automatically at startup time when the DBlibrary sybperl has been
linked against is System 10 or higher.

Michael
> 
> Comments anyone?
> 
> Michael
>