Mailing List Archive


Back to the month index Back to the list index
Mike Black (mblack@csihq.com)
Sun, 08 Sep 1996 09:13:06 -0400 

Message-Id: <1.5.4.32.19960908131306.00675c24@picard.csihq.com>
Date: Sun, 08 Sep 1996 09:13:06 -0400
From: Mike Black <mblack@csihq.com>
Subject: Re: [mSQL] A few miscellaneous questions...

At 10:39 PM 9/7/96 -0400, you wrote:
> This real number "bug" concerns me. If I insert a 2.5 into the
>database, sometimes it might print out as 2.50000000001. Not only does it
>screw up the output columinization, but it could possibly mess up a query
>too. Why is this behavior so sporadic? Aside from storing the real as a
>character, is there any way around this? I did check the current FAQ,
>and didn't see anything mentioned about it. My goal is to store monetary
>amounts as reals, and do comparasions with (>), (<), and (=). Maybe even
>some multiplication too. I can't do this with char-type or ints.
>

Nobody ever represents money amounts as real due to round-off error and
inexact storage. People either use char or multiple ints, or BCD (which
msql doesn't support). I think there may be plans for a money type in 2.0.
-
 /----------------------------------------------------------\
| Mike Black mblack@csihq.com 407-676-5118, x203 |
| Computer Science Innovations, Inc. 407-676-2355 FAX |
| Melbourne FL 32904-2314 http://www.csihq.com |
 \----------------------------------------------------------/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!