Re: dbconvert SYBMONEY to String

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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds