I want to store values in a bunch of currencies and I'm not too keen on the imprecise nature of floats. Being able to do math on them directly in queries is also a requirement.
Is Decimal the way to go here?
+10
A:
Decimal is the best way to go.
You can still do math within the queries.
bobwienholt
2008-10-29 21:35:28
A:
I concurr, decimal is the way to go. Never had problems with it.
Nikola Stjelja
2008-10-29 22:22:37
This isn't a forum. If you agree with an answer, vote it up. "I agree" isn't exactly the purpose of the "answers" portion. No offense meant.
Jonathan Sampson
2009-06-13 02:45:53
A:
my question is that how i can make a column in mysql table as(productno and it should have the data type 4alpha and 4numeric ) and it should be primary_key plz email
Faisal
2010-04-25 17:06:49