We are looking for advice on what to do here; we started out with our db holding ex VAT pricing now. Now the problem is the money type can only hold a few decimal places so when we are converting prices to incl vat it can't actually output the correct pricing and it comes our very ugly.
Unfortunately there is no bigmoney data type so we are in a bit of an awkward position :(
Any idea's?
Use DECIMAL data type instead. It's an exact number, like MONEY is. It's limited to a total of 38 digits, but you can configure the scale up to 38 digits if you like.
Eg: DECIMAL(10,6) would allow you to have a number like 1234.123456
DECIMAL(22,8) would allow you to have a number like 12345678912345.12345678
From BOL: Money Data Type, Overview: If a greater number of decimal places are required, use the decimal data type instead.
No comments:
Post a Comment