Skip to Content.
Sympa Menu

freetds - RE: g__numeric_bytes_per_precison

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: g__numeric_bytes_per_precison
  • Date: Mon, 2 Sep 2002 17:17:34 +0100


Thanks Freddy,

perhaps I worry unnecessarily.

I too have checked numerics from Sybase and SQL server, and they appear to
be being returned and converted correctly.

Bill

> -----Original Message-----
> From: ZIGLIO Frediano [SMTP:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: Monday, September 02, 2002 5:08 PM
> To: TDS Development Group
> Subject: [freetds] RE: g__numeric_bytes_per_precison
>
> > >
> > > Hi,
> > >
> > > does anyone know the thinking behind reverting this to a
> > > constant value ?
> > >
> > > I think I'd made this (kind of) dynamic, so that I could give
> > > it different
> > > values depending on whether I was talking TDS 5.0 (Sybase) or
> > > 7.0+ (MS),
> > > as the two databases sent numeric data differently (using different
> > > numbers of bytes to store different precisions)...
> > >
> > > Bill
> > >
> > This has been changed for many reason:
> > - connect to Sybase/MSSQL from same program at same time
> > - call converts before connect to db and act always the same way
> > If TDS7/8 return numeric with different bytes we should
> > correct this in
> > token.c (as we already make for byte ordering)
> >
> I did some test...
> TDS7 return always 17 bytes (1 for sign and 16 for number) little endian
> TDS8 return 5/9/13/17 bytes (removing leading zeroes, precision do not
> count...)
>
> freddy77
>
> =================================
> "STRICTLY PERSONAL AND CONFIDENTIAL
>
> This message may contain confidential and proprietary material for the
> sole
> use of the intended recipient. Any review or distribution by others is
> strictly prohibited. If you are not the intended recipient please contact
> the sender and delete all copies.
> The contents of this message that do not relate to the official business
> of
> our company shall be understood as neither given nor endorsed by it."
>
> =================================
>
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page