The best currency format in the database

Question

What is the best currency format to use in my database in conjunction with my ASP.NET web application. I'm not sure if float or decimal is better. Please note that I do not need settings for a specific culture.

Answer 1

If you are using SQL Server, you have a money type, which converts to a decimal type in .NET.

The decimal digit is a 128-bit base 10 floating-point number, not a binary floating-point number (which is floating / long), which makes it so that in most cases it does not lose accuracy, unlike binary floating-point numbers, which have a loss of accuracy as part of their design.

Here is a good article explaining decimals and floating point logic in general.

Answer 2

Do not use float.

decimal value, by specification decimal(17, 4), is probably acceptable. This means "17" places on the left and up to 4 decimal places.

Answer 3

, ( ). , .

float, .

Answer 4

. . , , , , , . .

Answer 5

FLOAT , . , , , ..

If you need fractional dollars (i.e. a cent), then choosing DECIMAL is appropriate. Otherwise, you can also stick with INTEGERS so as not to create penny problems.

Answer 6

int no=10000;
Console.WriteLine(no.ToString("N2"));