Subject | Triilions of Zim Dollars |
---|---|
Author | Maya Opperman |
Post date | 2008-01-18T14:03:25Z |
Hi All,
We have customers in Zimbabwe whose cost prices are now reaching the
trillions (and growing rapidly).
The government is refusing to devalue the currency again.
I am using decimal(18,5) to store the monetary values for our accounting
system. (In hind-sight decimal(18,2) would have given us a little more
lee-way)
I was wondering, are there any plans in the pipeline to increase the
maximum size allowed for the decimal data type? Or am I being doff (ie.
'silly' for non-South Africans) and there is another data type I can use
already..?
I've been googling around and it looks like MS SQL has a decimal(38)!
Thanks
Maya
[Non-text portions of this message have been removed]
We have customers in Zimbabwe whose cost prices are now reaching the
trillions (and growing rapidly).
The government is refusing to devalue the currency again.
I am using decimal(18,5) to store the monetary values for our accounting
system. (In hind-sight decimal(18,2) would have given us a little more
lee-way)
I was wondering, are there any plans in the pipeline to increase the
maximum size allowed for the decimal data type? Or am I being doff (ie.
'silly' for non-South Africans) and there is another data type I can use
already..?
I've been googling around and it looks like MS SQL has a decimal(38)!
Thanks
Maya
[Non-text portions of this message have been removed]