-
CREATE TABLE table_name (
id_col INT, col2
CHARACTER VARYING(20),
key_col SMALLINT NOT NULL, ...
CONSTRAINT key_unique UNIQUE(key_col), ... )
CREATE TABLE...
-
units in the UTF-16
character encoding int16_t, short, int
short Smallint short smallint INTEGER short i16 Unsigned: From 0 to 65,535,
which equals 216 − 1...
-
large object (BLOB)
Numeric types Exact numeric types (NUMERIC, DECIMAL,
SMALLINT, INTEGER, BIGINT)
Approximate numeric types (FLOAT, REAL,
DOUBLE PRECISION)...
-
Empress Embedded Database Static TINYINT, SQL_TINYINT, or INTEGER8;
SMALLINT, SQL_
SMALLINT, or INTEGER16; INTEGER, INT, SQL_INTEGER, or INTEGER32; BIGINT,...
-
Oracle — —
Teradata SKEW — — — — — — —
Teradata SKIP SQL-2023 — — — — — — —
SMALLINT SQL-2023 — —
MySQL Oracle — —
Teradata SOME SQL-2023 DB2
Mimer — — PostgreSQL...
- C#, Java, and SQL
programming languages. The
maximum range of a Word or
Smallint variable in the
Pascal programming language. The
number of
binary relations...
- (unsigned-byte 64)
bignum Scheme ISLISP bignum Pascal (FPC)
shortint byte
smallint word
longint longword int64
qword integer cardinal —
Visual Basic — Byte...
- Float4; IEEESingle; Double; Byte or Tinyint;
Integer or
Integer synonyms Smallint, Integer2, and Short;
LongInteger or
LongInteger synonyms Int, Integer...
- type can
store the
values TRUE and FALSE.
Numerical INTEGER (or INT),
SMALLINT and
BIGINT FLOAT, REAL and
DOUBLE PRECISION NUMERIC(precision, scale) or...
- data
types are
supported by CUBRID: For
numeric values:
integer numerics:
SMALLINT (16 bit),
INTEGER (32 bit),
BIGINT (64 bit)
floating point numerics: FLOAT...
