Welcome to Geeklog, Anonymous Monday, July 04 2022 @ 05:29 pm EDT

Geeklog Forums

only 255 users?

Status: offline


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

Status: offline


Site 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


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

Status: offline


Forum User
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:

M Indicates the maximum display size. The maximum legal display size is 255.

Robert-Reinder (rr@sodutch.com)

Robert-Reinder (rr@sodutch.com)

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