Prev: Access Log in
Next: How do you normalize a table?
From: John W. Vinson on 20 Jan 2010 13:22
On Wed, 20 Jan 2010 08:59:44 -0800, "Jeff Boyce" <nonsense(a)nonsense.com>
wrote:

>Tom
>
>I misunderstood. I thought the "Single" data type was one that offered
>considerably more precision than "Currency".

Well... apples and oranges.

Single is a 16-bit floating point number, which provides approximately 7
digits of precision, with an exponent numbers up to about 10^37. So you could
have 12345670000000000 but it would be indistinguishable from
12345670100000000 (because the 1 is lost in the roundoff error).

Currency is a scaled huge integer, with exactly four decimal places and a
range into the trillions. It doesn't have roundoff error but you can't store
10^37 in it either.
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2 3 4
Prev: Access Log in
Next: How do you normalize a table?