[ MySQL ] What data type for decimals?
| Author |
Message |
Amailer
|
 Posted: Wed Mar 17, 2004 11:24 am Post subject: [ 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? |
|
|
|
|
 |
Sponsor
Sponsor
|
|
|
PaddyLong
|
| Posted: Wed Mar 17, 2004 1:43 pm Post subject: (No subject) |
|
|
| float (smaller numbers), double (larger numbers) or decimal (decimal numbers stored as strings) |
|
|
|
|
|
Amailer
|
| Posted: Wed Mar 17, 2004 1:50 pm Post subject: (No subject) |
|
|
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 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?? <- if that how to do that with mysql...  |
|
|
|
|
|
|
|
Register
Wiki
Blog
Search
Turing
Chat Room
Members
