SQL Data types

CHAR - STR, length 0 - 255

VARCHAR - STR, variable length, max length specified

TEXT - STR, variable length, max length 65,535 characters

INT - INT, range - 2,147,483,648 to 2,147,483,647

SMALLINT - INT, range - 32,768 to 32,767

TINYINT - INT, range -128 to 127

BIGINT - INT, range - 9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

FLOAT - FLOAT point number, approximate number

DOUBLE - FLOAT point number, double precision

DECIMAL - FIXED point number, exact value

DATE - DATE, format YYYY-MM-DD

TIME - TIME, format HH:MM:SS

DATETIME - DATE and TIME, format YYYY-MM-DD HH:MM:SS

TIMESTAMP - TIMESTAMP, format YYYY-MM-DD HH:MM:SS, range 1970-01-01 00:00:01 UTC to 2038-01-19 03:14:07 UTC

YEAR - YEAR, format YYYY, range 1901 to 2155

BLOB - BINARY LARGE OBJECT, variable length, max length 65,535 bytes

BIT - BIT FIELD, length specified