10/31/02 04:17pm  
Status: offline

amckay

Forum User
Full Member
Registered: 03/23/02
Posts: 180
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
 11/01/02 01:30am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
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
 11/01/02 09:26pm  

Zergo

Anonymous
wonder what it is like to have -8388608 users.... that would be interesting.
 11/03/02 10:33am  
Status: offline

nederhoed

Forum User
Newbie
Registered: 01/20/02
Posts: 3

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. The maximum legal display size is 255.

---
Robert-Reinder (rr@sodutch.com)

Robert-Reinder (rr@sodutch.com)