Welcome to Geeklog Monday, October 19 2020 @ 08:30 pm EDT

Geeklog Forums

only 255 users?


Status: offline

amckay

Forum User
Full Member
Registered: 23/03/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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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

Zergo

Anonymous
wonder what it is like to have -8388608 users.... that would be interesting.
 Quote

Status: offline

nederhoed

Forum User
Newbie
Registered: 20/01/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

All times are EDT. The time is now 08:30 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