Data types

INTEGER or INT
DECIMAL(5,3) -- 12.345 (total, after dp)
NUMERIC(5,3)

FLOAT(p)
REAL
DOUBLE PRECISION
-- all round down

TEXT
REAL

DATE -- 'YYYY-MM-DD'
TIMESTAMP -- 'YYYY-MM-DD HH:MM:SS'

CHAR(6)    -- "jhon  "
VARCHAR(6) -- "jhon"

BLOB -- binary large object