Re: Field type for american money
[email protected] (Shawn McKenzie)
| Newsgroups | php.general |
|---|---|
| Message-ID | <[email protected]> |
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