Re: Field type for american money
| From: | Shawn McKenzie | Date: | Thu, 11 Jun 2009 20:36:11 +0000 |
| Subject: | Re: Field type for american money | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-293955@lists.php.net to get a copy of this message | ||
revDAVE wrote:
> Php - MySQL - newbie question
>
> - Field type for american money - int(11) seems to work fine
>
> - but also I tried decimal(10,2)
>
> Is one a better choice than another for american money usage?
>
>
> --
> Thanks - RevDave
> Cool @ hosting4days . com
> [db-lists 09]
>
>
>
If you are only interested in round dollar amounts then int should work
fine ;-) If you expect any fractions of a dollar (as I suspect you
will), such as 19.95 then use decimal.
--
Thanks!
-Shawn
http://www.spidean.com