-----------------------------------

Amailer

Wed Mar 17, 2004 11:24 am


[ MySQL  ] What data type for decimals?

-----------------------------------

Hey,
Im trying ot make it so that i can post versions for my downloads- but my problem is that i can't seem to find any field that can accpet decimals and that can be sorted by (varchar won't do...duh)

what's the data type im suppose to use for this?


-----------------------------------

PaddyLong

Wed Mar 17, 2004 1:43 pm



-----------------------------------

float (smaller numbers), double (larger numbers) or decimal (decimal numbers stored as strings)


-----------------------------------

Amailer

Wed Mar 17, 2004 1:50 pm



-----------------------------------

i tried them all...they all display as 0 :S ( i tried putting 0.1  btw )
NEVER MIND, i set it's length to 5,0 and now i set it to 5,1 :D (D how many decimals are allowed..jeez lol *smacks his head*)


ALSO, what is the standard way of displaying a version?
0.000
0.00
0.0
0.0.0??