I have a lot of soccer betting odds (hundreds per match and thousands of matches), for example:


What is the best datatype to store them? I need to occupy less storage as possible but also be efficient with sums, means etc.

They don't have a theoretical max value but I don't think they'll go above 100... Decimal(4,2) unsigned?

I know the question may be silly but I'm looking for a confirm from database experts...

1 Answer 1


I would use Decimal(4,2) if you are confident that 99.99 is the max value. Decimal(4,2) will consume 2 bytes while decimal(5,2) will consume 3 bytes but give you a safety net if the value were to exceed 99.99; it's up to you how confident your data set will stay under 100.

Not the answer you're looking for? Browse other questions tagged or ask your own question.