mySQL field structure question
| From: | Susan Ator | Date: | Wed, 01 Oct 2003 13:54:10 +0000 |
| Subject: | mySQL field structure question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30791@lists.php.net to get a copy of this message | ||
If I have a field in mySQL consisting of a number with 8 digits a decimal
point and 4 more digits what is the field type it needs to be to sort it
numerically?
I've tried decimal(8,4) but it converts everything to 99999999.9999. I've
also tried float but it doesn't sort numerically. All of the other integer
types cut off the decimal bit.
Any help would be appreciated.
Susan