Posted on: 10/31/02 04:17pm
By: amckay
Does mediumint(8) mean only 255 users?
I currently have 120 and it may be another few months til I have to worry about it, but the time will definitely come.
cheers,
-Alan
only 255 users?
Posted on: 11/01/02 01:30am
By: Dirk
Sites like www.geeklog.net (almost 2600 users now) would be in deep trouble then :-) Not to mention macosxhints.com or macfixit.com ...
No, the mediumint type can hold values between -8388608 and 8388607. Do you expect more than 8 million users in the near future? ;-)
bye, Dirk
only 255 users?
Posted on: 11/01/02 09:26pm
By: Anonymous (Zergo)
wonder what it is like to have -8388608 users.... that would be interesting.
Unsigned mediumint
Posted on: 11/03/02 10:33am
By: nederhoed
Wouldn't it be nicer to use the unsigned type? UNSIGNED MEDIUMINT has a range from 0 to 16777215
The 8 in MEDIUMINT(8) is used in mysql for spacing purposes:
MEDIUMINT(M)
M Indicates the maximum display size[*1] . The maximum legal display size is 255.
---
Robert-Reinder (rr@sodutch.com)