[Mono-list] SqlDBType.Money processed wrong with mono 2.6.4

[Piotr Wysocki]

On 06/13/2010 11:37 AM, Jacek Rużyczka wrote:
> Hi,
>
> Am Sonntag 13 Juni 2010 10:59:35 schrieb Josef Semmler:
>> Hi,
>>
>> i'm either doing someing stupid - or there is a bug with handling
>> SqlDBType.Money in mono 2.6.4 ... please help me.
>>
>> I have a sqlserver 2005 -  in a table with an attribute "Amount" of type
>> "Money" i try to store different values, which are in the c# code
>> represented as "decimal" - for any reason, the values are stored completly
>> wrong.
>>
> I would suppose that MONEY is a fixed-point data type, which means that the
> decimal point is always two positions left of the last digit. This is why your
> code stores values like 144.568 incorrectly.

That is not exactly true.
Bank applications for its calculations need four digits after the 
decimal point. Also consider that currency exchange rates use four 
digits after the decimal point :)

The MONEY data type is a 64-bit signed integer with the last four digits 
being after the decimal point, so the values covered are
from -2^63 / 10^4  to  (2^63 - 1) / 10^4

I think only those:
AddItem((decimal)12.34567);
AddItem((decimal)12.345678);
should not work, the rest should work.

Cheers,

-- 
Piotr Wysocki
Mobile Systems Research Labs, Poznan University of Technology