RE: MySQL DataTypes...

["Unix-Contractor, Wipro (CORP)" <Wipro.Unix-contractor@xxxxxxxxxxxx>]

Hi Vivek

	You can download the MySQL manual from MySQL site got to 7.2.1 you
will find all you required, just see following table


7.2.1 Column type storage requirements
The storage requirements for each of the column types supported by MySQL are
listed
below by category.
Numeric types
Column type Storage required
TINYINT 1 byte
SMALLINT 2 bytes
MEDIUMINT 3 bytes
INT 4 bytes
INTEGER 4 bytes
BIGINT 8 bytes
FLOAT(4) 4 bytes
FLOAT(8) 8 bytes
FLOAT 4 bytes
DOUBLE 8 bytes
DOUBLE PRECISION 8 bytes
REAL 8 bytes
DECIMAL(M,D) M bytes (D+2, if M < D)
NUMERIC(M,D) M bytes (D+2, if M < D)



Regards
Mohan


-----Original Message-----
From: Vivek [mailto:vivekb@xxxxxxxxxxxxx]
Sent: Monday, April 03, 2000 6:30 PM
To: Linux
Subject: [LIP] MySQL DataTypes...
Importance: High


Hi,

Anybody knows how many bytes does the

FIELD_TYPE_TINY
FIELD_TYPE_SHORT ... etc in MySQL occupy...

I mean, I need how many bytes do all those datatypes for the fields in a
table occupy ?
Where can I get that info ?


Vivek.
Versaware Inc.
vivekb@xxxxxxxxxxxxx


-----------------------------------------------------------------------
For information on this and other Linux India mailing lists check out
http://lists.linux-india.org/