MySQL Data Types
MySQL Data Types, with data type, and description.
Look inside
Showing 10 of 34 records. Sort the preview by selecting a column heading.
| ID | DataType | Description |
|---|---|---|
| 1 | CHAR(size) | 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 |
| 2 | VARCHAR(size) | 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 |
| 3 | BINARY(size) | Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1 |
| 4 | VARBINARY(size) | Equal to VARCHAR(), but stores binary byte strings. The size parameter specifies the maximum column length in bytes. |
| 5 | TINYBLOB | For BLOBs (Binary Large OBjects). Max length: 255 bytes |
| 6 | TINYTEXT | Holds a string with a maximum length of 255 characters |
| 7 | TEXT(size) | Holds a string with a maximum length of 65,535 bytes |
| 8 | BLOB(size) | For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data |
| 9 | MEDIUMTEXT | Holds a string with a maximum length of 16,777,215 characters |
| 10 | MEDIUMBLOB | For BLOBs (Binary Large OBjects). Holds up to 16,777,215 bytes of data |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
No source links are listed for this dataset. Ask about its coverage before using it where accuracy or recency matters.
A complete download includes all 34 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/mysqldatatypesChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.