5.5
0
1.5
3.5
etc...etc...?How large will the largest number be? Is there always at most a single decimal?
decimal(9,1) would work if you never have more than a single decimal palce. This would take up 5 bytes of storage, and nothing smaller would save you any space, so I would certainly leave it at that even if the number of digits to the left of the decimal (whole numbers) never exceeds 1.|||I've been experimenting and I think (4, 1) is going to work for me.
I just needed 0, 0.5, 1, 1.5, all the way up to 6.
Thanks!|||That is good, but keep in mind that even (4,1) is going to use the same 5 bytes of storage that (9,1) will. If there is ever any change of it getting larger, the extra space will not cost you anything.
Glad you got it going!
No comments:
Post a Comment