Typy danych:
// INTEGER 1
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8
--
//TEXT 2
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER(70)
NVARCHAR(100)
TEXT
CLOB
--
// NONE 3
BLOB
no datatype specified
--
// REAL 4
REAL
DOUBLE
DOUBLE PRECISION
FLOAT
--
// NUMERIC 5
NUMERIC
DECIMAL(10,5)
BOOLEAN
DATE
DATETIME
--
PRZYKLAD:
CREATE TABLE t1(
t TEXT, -- text affinity by rule 2
nu NUMERIC, -- numeric affinity by rule 5
i INTEGER, -- integer affinity by rule 1
r REAL, -- real affinity by rule 4
no BLOB -- no affinity by rule 3
);
