Computer Science Canada [ MySQL ] What data type for decimals? |
| Author: | Amailer [ 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? |
|
| Author: | PaddyLong [ Wed Mar 17, 2004 1:43 pm ] |
| Post subject: | |
float (smaller numbers), double (larger numbers) or decimal (decimal numbers stored as strings) |
|
| Author: | Amailer [ Wed Mar 17, 2004 1:50 pm ] |
| Post 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...  |
|