Agreed. Definitely odd that it doesnt behave exactly as documented, but it
does provide (9,2) precision, non? The fact that you can squeeze (10,2) into
the column in certain cases doesnt bother me.
Of course, if you came up with a patch to fix it, I dont think anyone would
complain.
dpk
----- Original Message -----
From: "Chris Johnson" <[EMAIL PROTECTED]>
To: "Jim Dickenson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 8:01 AM
Subject: Re: NUMERIC field contents
> On Sun, Sep 16, 2001 at 02:11:20PM -0700, Jim Dickenson wrote:
> > Does anyone have an opinion about the following? Are people using
decimal
> > type fields? Is it important for the database to allow only allowed
data?
>
> I use decimal datatype fields all the time for my monetary amounts. I've
> always treated them as behaving the way you suggest they should behave,
i.e.
> no extra digit space is provided by using the sign location. That MySQL
> behaves otherwise seems a bit counter-intuitive. I design my tables and
> software to treat it otherwise and also to never expect the database to
> provide the limits. My software insures the limits are never reached.
>
> --
> ..chris
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
