Comparison of Relational Database Management Systems - Data Types

Data Types

Type system Integer Floating point Decimal String Binary Date/Time Boolean Other
Altibase Static SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit) REAL(32-bit), DOUBLE(64-bit) DECIMAL, NUMERIC, NUMBER, FLOAT CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB BLOB, BYTE, NIBBLE, BIT, VARBIT DATE GEOMETRY
CUBRID Static SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit) FLOAT, REAL(32-bit), DOUBLE(64-bit) DECIMAL, NUMERIC CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB BLOB DATE, DATETIME, TIME, TIMESTAMP BIT MONETARY, BIT VARYING, SET, MULTISET, SEQUENCE
Drizzle Static INT (32-bit), BIGINT (64-bit) DOUBLE (aka REAL) (64-bit) DECIMAL BINARY, VARCHAR, VARBINARY, TEXT, BLOB DATETIME, DATE, TIMESTAMP ENUM, SERIAL
Empress Embedded Database Static TINYINT, SQL_TINYINT or INTEGER8

SMALLINT, SQL_SMALLINT or INTEGER16 INTEGER, INT, SQL_INTEGER or INTEGER32 BIGINT, SQL_BIGINT or INTEGER64

 REAL, SQL_REAL or FLOAT32

DOUBLE PRECISION, SQL_DOUBLE or FLOAT64 FLOAT or SQL_FLOAT EFLOAT

 DECIMAL, DEC, NUMERIC, SQL_DECIMAL or SQL_NUMERIC

DOLLAR

 CHARACTER,

ECHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING and NLSCHARACTER

CHARACTER LARGE OBJECT, TEXT, NATIONAL CHARACTER LARGE OBJECT, and NLSTEXT

 BINARY LARGE OBJECT or BLOB

BULK

 DATE,

EDATE, TIME, ETIME, EPOCH_TIME, TIMESTAMP, MICROTIMESTAMP

 BOOLEAN SEQUENCE 32

SEQUENCE
HSQLDB Static TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit) DOUBLE (64-bit) DECIMAL, NUMERIC CHAR, VARCHAR, LONGVARCHAR, CLOB BINARY, VARBINARY, LONGVARBINARY, BLOB DATE, TIME, TIMESTAMP, INTERVAL BOOLEAN OTHER (object), BIT, BIT VARYING, ARRAY
Informix Dynamic Server Static SMALLINT (16-bit), INT (32-bit), INT8 (64-bit proprietary), BIGINT (64-bit) SMALLFLOAT (32-bit), FLOAT (64-bit) DECIMAL (32 digits float/fixed), MONEY CHAR, VARCHAR, NCHAR, NVARCHAR, LVARCHAR, CLOB, TEXT TEXT, BYTE, BLOB, CLOB DATE, DATETIME, INTERVAL BOOLEAN SET, LIST, MULTISET, ROW, TIMESERIES, SPATIAL, USER DEFINED TYPES
Ingres Static TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit) FLOAT4 (32-bit), FLOAT (64-bit) DECIMAL C, CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, LONG NVARCHAR, TEXT BYTE, VARBYTE, LONG VARBYTE (BLOB) DATE, ANSIDATE, INGRESDATE, TIME, TIMESTAMP, INTERVAL N/A MONEY, OBJECT_KEY, TABLE_KEY, USER-DEFINED DATA TYPES (via OME)
Microsoft SQL Server Static TINYINT, SMALLINT, INT, BIGINT FLOAT, REAL NUMERIC, DECIMAL, SMALLMONEY, MONEY CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT BINARY, VARBINARY, IMAGE, FILESTREAM DATE, DATETIMEOFFSET, DATETIME2, SMALLDATETIME, DATETIME, TIME BIT CURSOR, TIMESTAMP, HIERARCHYID, UNIQUEIDENTIFIER, SQL_VARIANT, XML, TABLE
Microsoft SQL Server Compact (Embedded Database) Static TINYINT, SMALLINT, INT, BIGINT FLOAT, REAL NUMERIC, DECIMAL, MONEY NCHAR, NVARCHAR, NTEXT BINARY, VARBINARY, IMAGE DATETIME BIT TIMESTAMP, ROWVERSION, UNIQUEIDENTIFIER, IDENTITY, ROWGUIDCOL
MySQL Static TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit) FLOAT (32-bit), DOUBLE (aka REAL) (64-bit) DECIMAL CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB DATETIME, DATE, TIMESTAMP, YEAR BOOLEAN (aka BOOL) = synonym for TINYINT ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
Oracle Static + Dynamic (through ANYDATA) NUMBER BINARY_FLOAT, BINARY_DOUBLE NUMBER CHAR, VARCHAR2, CLOB, NCLOB, NVARCHAR2, NCHAR BLOB, RAW, LONGRAW, BFILE DATE, TIMESTAMP (with/without TIMEZONE), INTERVAL N/A SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType
Polyhedra Static INTEGER8 (8-bit), INTEGER(16-bit), INTEGER (32-bit) FLOAT32 (32-bit), FLOAT (aka REAL; 64-bit) N/A VARCHAR, LARGE VARCHAR (aka CHARACTER LARGE OBJECT) LARGE BINARY (aka BINARY LARGE OBJECT) DATETIME BOOLEAN N/A
PostgreSQL Static SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit) REAL (32-bit), DOUBLE PRECISION (64-bit) DECIMAL, NUMERIC CHAR, VARCHAR, TEXT BYTEA DATE, TIME (with/without TIMEZONE), TIMESTAMP (with/without TIMEZONE), INTERVAL BOOLEAN ENUM, POINT, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, BIT, UUID, XML, arrays
RDM Embedded Static tinyint, smallint, integer, bigint real, float, double N/A char, varchar, wchar, varwchar, long varchar, long varwchar binary, varbinary, long varbinary date, time, timestamp bit N/A
RDM Server Static tinyint, smallint, integer, bigint real, float, double decimal, numeric char, varchar, wchar, varwchar, long varchar, long varwchar binary, varbinary, long varbinary date, time, timestamp bit rowid
SQLite Dynamic INTEGER (64-bit) REAL (aka FLOAT, DOUBLE) (64-bit) N/A TEXT (aka CHAR, CLOB) BLOB N/A N/A N/A
UniData Dynamic N/A N/A N/A N/A N/A N/A N/A N/A
UniVerse Dynamic N/A N/A N/A N/A N/A N/A N/A N/A
Xeround Cloud Database Static TINYINT (8-bit), SMALLINT (16-bit), MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit) FLOAT (32-bit), DOUBLE (aka REAL) (64-bit) DECIMAL CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB DATETIME, DATE, TIMESTAMP, YEAR BOOLEAN (aka BOOL) = synonym for TINYINT ENUM, SET
Type system Integer Floating point Decimal String Binary Date/Time Boolean Other

Read more about this topic:  Comparison Of Relational Database Management Systems

Famous quotes containing the words data and/or types:

    “To write it, it took three months; to conceive it three minutes; to collect the data in it—all my life.”
    —F. Scott Fitzgerald (1896–1940)

    “The wider the range of possibilities we offer children, the more intense will be their motivations and the richer their experiences. We must widen the range of topics and goals, the types of situations we offer and their degree of structure, the kinds and combinations of resources and materials, and the possible interactions with things, peers, and adults.”
    —Loris Malaguzzi (1920–1994)