FreeTDS Development Group

[Ken Collins <ken AT metaskills.net>]

Thanks, did not recognize this at first. Our new client is doing so correctly 
now too.

 - Thanks,
   Ken


On Oct 13, 2010, at 11:45 PM, James K. Lowden wrote:

> Ken Collins wrote:
>> 1> SELECT [id], [money] FROM [datatypes] WHERE [money] IS NOT NULL;
>> 2> GO
>> id     money
>> 161    4.20
>> 162    -922337203685477.58
>> 163    922337203685477.58
> 
> The above doesn't show any loss of precision; it shows only that the
> client you're using prints MONEY fields as strings with two digits of
> precision.  That's that client's choice.  
> 
>       select 10000 * sum(money) from datatypes where id in (162,163)
> 
> should show -1.  
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds