9.1.Datatypes

CHARACTER

CHARACTER

VARCHAR

VARCHAR'('INTNUM')'

NVARCHAR

NVARCHAR'('INTNUM')'

CHAR'('INTNUM')'

NUMERIC

NUMERIC

NUMERIC'('INTNUM')'

NUMERIC'('INTNUM','INTNUM')'

DECIMAL

DECIMAL

DECIMAL'('INTNUM')'

DECIMAL'('INTNUM','INTNUM')'

INTEGER

INT

INTEGER

SMALLINT

FLOAT

FLOAT

FLOAT'('INTNUM')'

REAL

REAL

DOUBLE PRECISION

LONG VARCHAR

BLOB data

VARBINARY [( precision )]

Binary data

LONG VARBINARY

Binary BLOB data

TIMESTAMP

TIMESTAMP

DATETIME

TIME

DATE

<UDT>

User Defined Type with varbinary-like size properties.

LONG <UDT>

User Defined Type with LONG varbinary-like size properties.

LONG XML

LONG XML BLOB-like data type.

[Note] Note:

User Defined Types can be created from native or external types, composites or classes from any hosted language such as Java or .Net. Any User Defined Type can be used to define a column in a CREATE TABLE statement.