>>>
>>>BTW, we also saw currency fields unexpectedly changing. But those fields changed by trillions. It was asy to spot those errors. :)
>>>
>>
>>It's probably the same thing: since currency are stored as fp numbers, a change in the seventh bit will most likely cause a radical value change (in the exponent, for instance). You could try to check this out with the
hexedit tool - and compare values before and after your correction. So, at random places in your database files, bytes are being ored with 10000000. A virus attack? RAM or network problems?
>
>While I basically agree with your analysis, I don't think currency values have an exponent. I understand they are stored as an integer. The value stored as an integer would be the value the user sees, multiplied with 10,000.
Actually, a 64 byte integer. You can see they take 8 bytes when you add one to a table.