Numeric

NUMBER (p,s)

In ORACLE, NUMBER data type stores zero as well as positive and negative fixed numbers with absolute value.

It works exactly same in ALTIBASE HDB as well.

FLOAT (p)

A subtype of the NUMBER data type having precision p.

A FLOAT value is represented internally as NUMBER.

The precision p can range from 1 to 126 binary digits

Icon

A subtype in the above me does not mean a native data type, inherently supported from the beginning by ALTIBASE HDB,
by a subordinate data type of certain data type.

Even if a user creates table using subtype, it internally transforms to a native data type,

and works as a native data type whenever a user performs a query execution on the table having subtype.

It can be major reason of performance degradation.

BINARY_FLOAT

32bit, single-precision floating-point number data type.

Each BINARY_FLOAT value requires 4 bytes.

ALTIBASE HDB does not support this data type but you can use REAL type instead.

ALTIBASE HDB REAL type stores 4-byte fixed decimal floating value and it is equivalent to the float type in C Language.

BINARY_DOUBLE

64bit, double-precision floating-point number data type.

Each BINARY_DOUBLE value requires 8 bytes.

ALTIBASE HDB does not support this data type but you can use DOUBLE type instead.

ALTIBASE HDB DOUBLE type stores 8-byte fixed decimal floating value and it is equivalent to the double type in C Language.

NUMERIC (p,s)

This is ANSI data type.

This data type can be converted to NUMBER(p, s) data type in ORACLE.

So, this conversion rule is identical to "NUMBER(p, s)".

DECIMAL (p,s)

This is ANSI data type.

This data type can be converted to NUMBER(p, s) data type in ORACLE.

So, this conversion rule is identical to "NUMBER(p, s)".

INT

This is ANSI data type.

This data type can be converted to NUMBER(38) in ORACLE.

So, this data type can be converted to NUMBER(38) in ALTIBASE HDB as well.

INTEGER

Same as above INT.

SMALLINT

Same as above INT.

FLOAT

This is ANSI data type.

This data type can be converted to NUMBER(126) in ORACLE.

But, ALTIBASE HDB NUMBER type maximum precesion is 38.

So, if you want to change, it can be FLOAT(38).

DOUBLE

This is ANSI data type.

This data type can be converted to NUMBER(126) in ORACLE.

But, ALTIBASE HDB NUMBER type maximum precesion is 38.

So, if you want to change, it can be FLOAT(38).

REAL

This is ANSI data type.

This data type can be converted to NUMBER(63) in ORACLE.

But, ALTIBASE HDB NUMBER type maximum precesion is 38.

So, if you want to change, it can be FLOAT(38).