FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

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')