Best Currency format in database
asp.net, c#, sql-server
Solution
If you're using SQL Server, you have the 'money' type, which translates to a decimal type in .NET.
Decimal is a 128bit base 10 floating point number, rather than a binary floating point (which float/long are), which makes it so that in most cases it doesn't lose precision, unlike binary floating point numbers, which have accuracy loss as part of their design.
Here's a nice article explaining decimals and floating point logic in general.
Problem
What is the best currency format to use in my database in conjunction with my ASP.NET web app. I am not sure if float or decimal is better. Please note, I will not need culture specific settings.