Technology · Reference dataset
MySQL Data Types
MySQL data types and descriptions of the values they store.
$69 once covers this and 431 other datasets, plus 33 collections, for 365 days. No automatic renewal. Have a pass?
Preview the records
First 5 and last 5 of 34 records · Last changed July 17, 2026
| Data type | Description |
|---|---|
| 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 |
| 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 |
| BINARY(size) | Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1 |
| VARBINARY(size) | Equal to VARCHAR(), but stores binary byte strings. The size parameter specifies the maximum column length in bytes. |
| TINYBLOB | For BLOBs (Binary Large OBjects). Max length: 255 bytes |
| 24 more records · Download options | |
| DATE | A date. Format: YYYY-MM-DD. The supported range is from '1000-01-01' to '9999-12-31' |
| DATETIME(fsp) | A date and time combination. Format: YYYY-MM-DD hh:mm:ss. The supported range is from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. Adding DEFAULT and ON UPDATE in the column definition to get automatic initialization and updating to the current date and time |
| TIMESTAMP(fsp) | A timestamp. TIMESTAMP values are stored as the number of seconds since the Unix epoch ('1970-01-01 00:00:00' UTC). Format: YYYY-MM-DD hh:mm:ss. The supported range is from '1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07' UTC. Automatic initialization and updating to the current date and time can be specified using DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP in the column definition |
| TIME(fsp) | A time. Format: hh:mm:ss. The supported range is from '-838:59:59' to '838:59:59' |
| YEAR | A year in four-digit format. Values allowed in four-digit format: 1901 to 2155, and 0000. MySQL 8.0 does not support year in two-digit format. |
Free sample files (up to 10 rows): CSV JSON XML
Open the sample in a free tool: CSV to JSON · JSON formatter · SQL INSERT generator · CSV to XML
CSV / JSON / XML
Put this data to work.
All 34 records, in your choice of format.
The free sample stops at 10 rows. A Data Pass removes the limit here and across the site, so you can stop collecting data and start using it.
- Every record in 432 datasets, this one included
- All 33 collections in full: more than 4 million rows of ZIP codes, schools, occupations and more
- CSV, JSON and XML, whole-category ZIPs, and 2,500 API requests a day
$69 once, for 365 days. No subscription and no automatic renewal, and what you download is yours to keep using.
Your key arrives by email after payment. Use it here to download the complete file.
Already have a pass?
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid.
Downloaded a CSV? Convert CSV to JSON, generate SQL inserts, remove duplicate lines, or sort a list with the free tools.
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
MySQL Data Types has 34 records and 2 fields: Data type, Description.
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.