Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
Built-in data types
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The SQL standard and most RBDMS agree on a set of well-known primitive data types with a different set of names and variations. These include the following groups of types:
- Numeric integers: TINYINT, SMALLINT, INTEGER, BIGINT
- Numeric floats: REAL, DOUBLE, FLOAT
- Numeric decimals: NUMERIC, DECIMAL
- Strings of fixed length: CHAR
- Strings of variable length: VARCHAR, CLOB
- Binary strings of fixed length: BINARY
- Binary strings of variable length: VARBINARY, BLOB
- Temporal data types: DATE, TIME, TIMESTAMP
In addition to the above primitives, there are also a few more specialised data types that are frequently seen in RDBMS, including:
Table of contents
- 3.11.2.1.
- BIGINT (Long)
- 3.11.2.2.
- BIGINT UNSIGNED (ULong)
- 3.11.2.3.
- BINARY (byte[])
- 3.11.2.4.
- BIT (Boolean)
- 3.11.2.5.
- BLOB (byte[])
- 3.11.2.6.
- BOOLEAN (Boolean)
- 3.11.2.7.
- CHAR (String)
- 3.11.2.8.
- CLOB (String)
- 3.11.2.9.
- DATE (Date)
- 3.11.2.10.
- DECIMAL (BigDecimal)
- 3.11.2.11.
- DECIMAL INTEGER (BigInteger)
- 3.11.2.12.
- DOUBLE (Double)
- 3.11.2.13.
- FLOAT (Double)
- 3.11.2.14.
- INSTANT (Instant) (new)
- 3.11.2.15.
- INTEGER (Integer)
- 3.11.2.16.
- INTEGER UNSIGNED (UInteger)
- 3.11.2.17.
- INTERVAL (YearToSecond)
- 3.11.2.18.
- INTERVAL DAY TO SECOND (DayToSecond)
- 3.11.2.19.
- INTERVAL YEAR TO MONTH (YearToMonth)
- 3.11.2.20.
- JSON (JSON)
- 3.11.2.21.
- JSONB (JSONB) (new)
- 3.11.2.22.
- LOCALDATE (LocalDate)
- 3.11.2.23.
- LOCALDATETIME (LocalDateTime)
- 3.11.2.24.
- LOCALTIME (LocalTime)
- 3.11.2.25.
- LONGNVARCHAR (String)
- 3.11.2.26.
- LONGVARBINARY (byte[])
- 3.11.2.27.
- LONGVARCHAR (String)
- 3.11.2.28.
- NCHAR (String)
- 3.11.2.29.
- NCLOB (String)
- 3.11.2.30.
- NUMERIC (BigDecimal)
- 3.11.2.31.
- NVARCHAR (String)
- 3.11.2.32.
- OFFSETDATETIME (OffsetDateTime)
- 3.11.2.33.
- OFFSETTIME (OffsetTime)
- 3.11.2.34.
- OTHER (Object)
- 3.11.2.35.
- REAL (Float)
- 3.11.2.36.
- RECORD (Record)
- 3.11.2.37.
- RESULT (Result)
- 3.11.2.38.
- ROWID (RowId) (new)
- 3.11.2.39.
- SMALLINT (Short)
- 3.11.2.40.
- SMALLINT UNSIGNED (UShort)
- 3.11.2.41.
- TIME (Time)
- 3.11.2.42.
- TIMESTAMP (Timestamp)
- 3.11.2.43.
- TIMESTAMP WITH TIME ZONE (OffsetDateTime)
- 3.11.2.44.
- TIME WITH TIME ZONE (OffsetTime)
- 3.11.2.45.
- TINYINT (Byte)
- 3.11.2.46.
- TINYINT UNSIGNED (UByte)
- 3.11.2.47.
- UUID (UUID)
- 3.11.2.48.
- VARBINARY (byte[])
- 3.11.2.49.
- VARCHAR (String)
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!