SQL Data Types

SQL column data types — INT, VARCHAR, TEXT, BOOLEAN, DATE, TIMESTAMP, JSON, DECIMAL. This category documents 31 SQL data types entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: INT, VARCHAR(n), TEXT, BOOLEAN / BOOL, DATE, TIMESTAMP / DATETIME, DECIMAL / NUMERIC, JSON, FLOAT / DOUBLE, TINYINT / SMALLINT / MEDIUMINT / BIGINT, ENUM, SET, BLOB / LONGBLOB, BINARY / VARBINARY, BIT, UUID / GUID, GEOMETRY / POINT / LINESTRING, INTERVAL, DataType Mapping (Cross-DB), MONEY / SMALLMONEY, HIERARCHYID, XML Data Type, ARRAY Data Type, ROWVERSION / TIMESTAMP (SQL Server), FILESTREAM (SQL Server), SPATIAL Data Types (GEOGRAPHY/GEOMETRY), ROW STORE vs COLUMN STORE, PostgreSQL NUMERIC Types, PostgreSQL BOOLEAN Type, PostgreSQL GEOMETRIC Types, PostgreSQL INTERVAL Type. Not sure where to start? INT and VARCHAR(n) are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.