freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...
- From: Jaye Mathisen <mrcpu AT internetcds.com>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...
- Date: Thu, 2 Sep 1999 13:54:12 -0700 (PDT)
I will rebuild DBD::Sybase and see if I'm out of date.
Will post back l8r.
On Thu, 2 Sep 1999, Michael Peppler wrote:
> Jaye Mathisen writes:
> >
> >
> > not exactly sure what's happening.
> >
> > float works, but a column of type money doesn't.
> > I always get 0.
> >
> >
> > sqsh-1.7 linked with the freeTDS libs returns the right value.
> >
> > I did check for the "defined $_" issue from before.
> >
> >
> > Note that the column I'm selecting against is in a view, rather than a
> > table, but it shouldn't make any difference that I can see.
> >
> >
> > SQL Server 6.5 SP5A, TDS ver = 4.2
> >
> >
> > I haven't supped and built for a few days.
> >
> >
> > TIMESTAMP values don't match isql at all, and in fact, seem a little
> > clustered for valid values.
> >
> > timestamp: |0x00000001000ef41c|
> > timestamp: |0x00000001000ef425|
> > timestamp: |0x00000001000ef42f|
> >
> >
> > >From isql:
> >
> > timestamp: 0x0000000100530d0a
> > 0x000000010411f4ff
> > 0x0000000104344371
> >
> > for the same columns.
> >
> > sqsh matches isql as well. So that probably means the problem is in
> > DBD::Sybase.
>
> Weird.
>
> DBD::Sybase doesn't do anything apart from binding the return value
> (with ct_bind()) to a CS_CHAR_TYPE. I've not looked at the sqsh code,
> so I don't know what Scott does that is different from my code.
>
> Michael
> --
> Michael Peppler -||- Data Migrations Inc.
> mpeppler AT peppler.org -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list AT isug.com
>
> ---
> You are currently subscribed to freetds as: mrcpu AT internetcds.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
-
DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken...,
Jaye Mathisen, 09/02/1999
- <Possible follow-up(s)>
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Michael Peppler, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Jaye Mathisen, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Mark Schaal, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Mark Schaal, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
- Re: DBD::Sybase or FreeTDS ...money type/TIMESTAMP seems broken..., Brian Bruns, 09/02/1999
Archive powered by MHonArc 2.6.24.