Question

Explain different datatypes in database

Answer 1

Data Types
PointBase supports the following data types for its column and parameter declarations.
CHARACTER [(length)] or CHAR [(length)]
VARCHAR (length)
BOOLEAN
SMALLINT
INTEGER or INT
DECIMAL [(p[,s])] or DEC [(p[,s])]
NUMERIC [(p[,s])]
REAL
FLOAT(p)
DOUBLE PRECISION
DATE
TIME
TIMESTAMP
CLOB [(length)] or CHARACTER LARGE OBJECT [(length)] or CHAR LARGE OBJECT [(length)]
BLOB [(length)] or BINARY LARGE OBJECT [(length)]

Answer 2

CHARACTER [(length)] or CHAR [(length)]
VARCHAR (length)
BOOLEAN
SMALLINT
INTEGER or INT
DECIMAL [(p[,s])] or DEC [(p[,s])]
NUMERIC[(p[,s])]
REAL
FLOAT(p)
DOUBLE 
PRECISION
DATE
TIME
TIMESTAMP
CLOB [(length)] or CHARACTER LARGE OBJECT [(length)] or CHAR LARGE OBJECT [(length)]
BLOB [(length)] or BINARY LARGE OBJECT [(length