Geek Answers Handbook

Saving and displaying exchange rates

I need to store SQL data for a SQL Server 2008 R2 course.

An application using this data is developed in C #. The column supporting the exchange rate will have to store conversions in both directions - that is, I would prefer to have a fixed accuracy, but a variable scale.

What type of data should I choose on SQL Server that can be mapped to C # to avoid data loss? I am looking at the MSDN, the supplied mapping matrix , and I cannot find anything that I can handle safely.

  • A float (53) may be possible, but float are approximate values.
  • Money is true only ten thousandth unit

I have a decimal number left. However, they do offer fixed scales. And here is where I am at a standstill:

If I need to save a number like 0.0104182 but also 123.673 , I set the precision to 10 as my requirement. But how do I set a scale that can fully account for this accuracy?

+4
source share
1 answer

For exchange rates, I will use decimal (19, 9) or so.

You must consider the "phone number" rates

Examples at current rates 1 British pound

  • 13,835.87699 Indonesian Rupiah
  • 33,016.24786 Vietnamese Dong
+14
source

More articles:


All Articles