The secure CMS.

Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 03:19 pm EST

Geeklog Forums

only 255 users?

 New Topic  Post Reply
 10/31/02 04:17pm (Read 2,252 times)  
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
 Quote
 11/01/02 01:30am  
Status: offline

Dirk

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

Zergo

Anonymous
wonder what it is like to have -8388608 users.... that would be interesting.
 Quote
 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)
 Quote
 New Topic  Post Reply
All times are EST. The time is now 03:19 pm.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content