Which type should I use for storing prices (money)?

FLOAT, DECIMAL ... or something else?

Format is 0.00



Thanks

You should use decimal

Thanks Paul.

Similar post:

http://www.gossamer-threads.com/...orum.cgi?post=203942

But, I don't understand "precision" and "decimal" part of it.

Maybe Length/Set = 12,2 ?

According to the manual, precision is the number of digits (how wide the field is) and the decimal is how many to the right of the decimal point.

(12,2) would be:

1234567890.12

In it's "best" case. Negative numbers, will be one place shorter, as will some flavors of Unix or other OS's that count the '.' as a place (user reported quirks).

If you want to handle numbers such as 123,456,789.00 you'd be better off defining a field as (13,2) to handle that.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

I've put this in the SQL forum as I think it's more suited there.

Thanks for the explanation

And now it's back

Just noticed that (post above)

Something is wrong with the forum because I am 100% sure that I posted this thread in the right forum (I know because I still have old window open and it shows Home: Products: Links SQL: Discussions:
Price (money) field


Or, maybe I'll just go to sleep!

Back where?


Which forum did you post in originally?

Nevermind

Sorry!

Back to the original topic.



When I go to MySQLMan > Add Fields and select
DECIMAL for Type field and 12,2 for Length/Set
everything is OK until I hit Resync Database.

DECIMAL changes to FLOAT.

Is this the way it is supposed to work or ...?

Anybody?