what are most commonly used data types in msql
TINYBLOB or TINYTEXT—A BLOB or TEXT column with a maximum length of
255 characters. You do not specify a length with TINYBLOB or TINYTEXT.
BLOB or TEXT—A field with a maximum length of 65,535 characters. BLOBs are
Binary Large Objects and are used to store large amounts of binary data, such
as images or other types of files. Fields defined as TEXT also hold large
amounts of data; the difference between the two is that sorts and comparisons
on stored data are case sensitive on BLOBs and are not case sensitive in TEXT
fields. You do not specify a length with BLOB or TEXT.
. CHAR(M)—A fixed-length string between 1 and 255 characters in length (for
example, CHAR(5)), right-padded with spaces to the specified length when
stored. Defining a length is not required, but the default is 1.
. VARCHAR(M)—A variable-length string between 1 and 255 characters in length;
for example, VARCHAR(25). You must define a length when creating a VARCHAR
. MEDIUMBLOB or MEDIUMTEXT—A BLOB or TEXT column with a maximum length
of 16,777,215 characters. You do not specify a length with MEDIUMBLOB or
. LONGBLOB or LONGTEXT—A BLOB or TEXT column with a maximum length of
4,294,967,295 characters. You do not specify a length with LONGBLOB or LONGTEXT.
. ENUM—An enumeration, which is a fancy term for list. When defining an
ENUM, you are creating a list of items from which the value must be selected
(or it can be NULL). For example, if you want your field to contain A or B or C,
you would define your ENUM as ENUM (‘A’, ‘B’, ‘C’), and only those values
(or NULL) could ever populate that field. ENUMs can have 65,535 different
values. ENUMs use an index for storing items.
The SET type is similar to ENUM in that it is defined as a list. However, the SET
type is stored as a full value rather than an index of a value, as with ENUMs.