>From: Michael Peppler <[EMAIL PROTECTED]>
>To: "David Sevier" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: DBD:Sybase and $sth->{SCALE}
>Date: Mon, 7 May 2001 14:24:36 -0700 (PDT)
>
>David Sevier writes:
> > When done using DBD:ODBC through the proxy, it works fine. But with
> > DBD:Sybase, the metadata returned for items of type Float are a
>problem.
> > They always come back with a Pecision of 8 and a Scale that is empty
>(null).
>
>A Float doesn't have any scale, and precision in this case is the
>number of bytes used (float is 8, real is 4).
>
>Michael
>--
>Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
>http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
>International Sybase User Group - http://www.isug.com
>Sybase on Linux mailing list: [EMAIL PROTECTED]
Ah! That makes sense. The next question then, is how do I get a scale out of
it? In SQL Server, one field (a $ amount field) is showing up as Decimal
with Precision 8 and Scale 2. With DBD:ODBC through DBIProxy, I get that as
the output for the metadata. With DBD:Sybase, however, I get the Float with
Precision 8 and no Scale. What do I need to do to get the scale for the
field if floats don't have scale?
Thanks,
David Sevier
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
