[KLUG Programming] MySQL INT sizes

[Adam Tauno Williams]

On Thu, 2004-07-15 at 13:09, Jamie McCarthy wrote:
> pikitfense at hotmail.com (Thomas Ross) writes:
> 
> > Ditto to everything Jamie said, with this note: isn't an int only
> > -65535 to 65536 ?  Or is that called a smallint?
> 
> In MySQL-speak,
> 
> TINYINT      8 bits
> SMALLINT    16 bits
> MEDIUMINT   24 bits
> INT         32 bits
> BIGINT      64 bits
> 
> I don't know how other DBs define these things, sorry :)

Everyone I've used does this exact same this with smallint & int. 
tinyint & mediumint are pretty wierd. Tinyint in most other databases is
"byte".  bigint is usually called a longint or long-something, but is
always provided.