Specifications

Table 8.10 shows the TEXT and BLOB types. The maximum length of a TEXT field in characters
is the maximum size in bytes of files that could be stored in that field.
TABLE 8.10 TEXT and BLOB Types
Maximum Length
Type (Characters) Description
TINYBLOB 2
8
-1 A tiny binary large object (BLOB) field
(that is, 255)
TINYTEXT 2
8
-1 A tiny TEXT field
(that is, 255)
BLOB 2
16
-1 A normal sized BLOB field
(that is, 65,535)
TEXT 2
16
-1 A normal sized TEXT field
(that is, 65,535)
MEDIUMBLOB 2
24
-1 A medium-sized BLOB field
(that is, 16,777,215)
MEDIUMTEXT 2
24
-1 A medium-sized TEXT field
(that is, 16,777,215)
LONGBLOB 2
32
-1 A long BLOB field
(that is, 4,294,967,295)
LONGTEXT 2
32
-1 A long TEXT field
(that is, 4,294,967,295)
Table 8.11 shows the ENUM and SET types.
T
ABLE 8.11 SET and ENUM Types
Maximum
Type Values in Set Description
ENUM(‘value1’, 65535 Columns of this type can only hold one of
‘value2’,...) the values listed or NULL.
SET(‘value1’, 64 Columns of this type can hold a set of the
‘value2’,...) specified values or NULL.
Creating Your Web Database
C
HAPTER 8
8
CREATING YOUR
WEB DATABASE
205
11 7842 CH08 3/6/01 3:38 PM Page 205