| CHAR | fixed-length nonbinary(character) string |
| VARCHAR | variable-length nonbinary string |
| BINARY | fixed-length binary string |
| VARBINARY | variable-length binary string |
| TINYBLOB | Very small BLOB(binary large object) |
| BLOB | Small BLOB |
| MEDIUMBLOB | Medium-sized BLOB |
| LONGBLOB | Large BLOB |
| TINYTEXT | A very small nonbinary string |
| TEXT | Small nonbinary string |
| MEDIUMTEXT | Medium-sized nonbinary string |
| LONGTEXT | Large nonbinary string |
| ENUM | An enumeration; each column value is ASSIGNED, ONE enumeration member |
| SET | A set; each column value is assigned ZERO or more set members |
| NULL | NULL in SQL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. This value is different than a zero value or a field that contains spaces. |
