| Date Type<\/th>\n | Description<\/th>\n<\/tr>\n<\/thead>\n |
|---|---|
| CHAR(size)<\/td>\n | A FIXED length string (can contain letters, numbers, and special characters). The size parameter specifies the column length in characters - can be from 0 to 255. Default is 1<\/td>\n<\/tr>\n |
| VARCHAR(size)<\/td>\n | A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum column length in characters - can be from 0 to 65535<\/td>\n<\/tr>\n |
| BINARY(size)<\/td>\n | Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1<\/td>\n<\/tr>\n |
| VARBINARY(size)<\/td>\n | Equal to VARCHAR(), but stores binary byte strings. The size parameter specifies the maximum column length in bytes.<\/td>\n<\/tr>\n |
| TINYBLOB<\/td>\n | For BLOBs (Binary Large OBjects). Max length: 255 bytes<\/td>\n<\/tr>\n |
| TINYTEXT<\/td>\n | Holds a string with a maximum length of 255 characters<\/td>\n<\/tr>\n |
| TEXT(size)<\/td>\n | Holds a string with a maximum length of 65,535 bytes<\/td>\n<\/tr>\n |
| BLOB(size)<\/td>\n | For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data<\/td>\n<\/tr>\n |
| MEDIUMTEXT<\/td>\n | Holds a string with a maximum length of 16,777,215 characters<\/td>\n<\/tr>\n |
| MEDIUMBLOB<\/td>\n | For BLOBs (Binary Large OBjects). Holds up to 16,777,215 bytes of data<\/td>\n<\/tr>\n |
| LONGTEXT<\/td>\n | Holds a string with a maximum length of 4,294,967,295 characters<\/td>\n<\/tr>\n |
| LONGBLOB<\/td>\n | For BLOBs (Binary Large OBjects). Holds up to 4,294,967,295 bytes of data<\/td>\n<\/tr>\n |
| ENUM(val1, val2, val3, ...)<\/td>\n | A string object that can have only one value, chosen from a list of possible values. You can list up to 65535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted. The values are sorted in the order you enter them<\/td>\n<\/tr>\n |
| SET(val1, val2, val3, ...)<\/td>\n | A string object that can have 0 or more values, chosen from a list of possible values. You can list up to 64 values in a SET list<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nreference<\/h2>\n |