numeric data from sql 7.0
Sasha Dolgy
sdolgy at birdonawire.com
Thu Mar 8 11:03:27 EST 2001
On Wed, 7 Mar 2001, Brian Bruns wrote:
> Date: Wed, 7 Mar 2001 20:44:23 -0500 (EST)
> From: Brian Bruns <camber at ais.org>
> Reply-To: TDS Development Group <freetds at franklin.oit.unc.edu>
> To: TDS Development Group <freetds at franklin.oit.unc.edu>
> Subject: [freetds] Re: numeric data from sql 7.0
>
>
> Ok,
>
> Can someone tell me which protocol versions this affects? 4.2? 7.0? both?
>
> All the numeric stuff was moved from convert.c to numeric.c
>
> Cheers,
>
> Brian
I will check out numeric.c, thanks. I'll give a bit more info in hopes it
can help you, or others replicate the problem.
I make a query and ask for 3000 rows. all the results returned are
numeric. at about row 2000 i have a numeric value that is 10 bits.
4444238300
from there, the rest of the values that are returned after that value are
skewed. usually resulting in a 9 bit number. needless to say, all the
data returned is not correct.
I compiled with tdsver=7.0 and use it in conjunction with a mssql 2000
machine. testing it against sql 7.0 reproduces the same results.
hope this helps.
Thanks again
-sasha
More information about the FreeTDS
mailing list