Question

Explain different datatypes in database

Answer 1

This chapter describes all of the SQL data types that PointBase supports. Data types define what type of data a column can contain. The following sections describe each PointBase data type in detail and discuss converting data types. Tables are provided at the end of the chapter to show the mappings between PointBase data types and industry standard and other common non-standard data types.

Data Types

PointBase supports the following data types for its column and parameter declarations.

CHARACTER [(length)] or CHAR [(length)]VARCHAR (length)BOOLEANSMALLINTINTEGER or INTDECIMAL [(p[,s])] or DEC [(p[,s])]NUMERIC [(p[,s])]REALFLOAT(p)DOUBLE PRECISIONDATETIMETIMESTAMPCLOB [(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)]