Data type Conversion Table

Data type Conversion Table

The following table summarizes the mapping from the ORACLE Data types to corresponding ALTIBASE HDB data types.

Category	ORACLE	ALTIBASE HDB	Comments
Character	CHAR(n)	CHAR(n)	ALTIBASE HDB can store 32K characters in CHAR column. cf) ORACLE CHAR max length : 4000
	CHARACTER(n)	CHAR(n)
	VARCHAR(n)	VARCHAR (n)	ALTIBASE HDB can store 32K characters in VARCHAR column. cf) ORACLE VARCHAR max length : 4000
	VARCHAR2(n)	VARCHAR2(n)	ALTIBASE HDB can store 32K characters in VARCHAR2 column. cf) ORACLE VARCHAR2 max length : 4000
	NCHAR(n)	NCHAR(n)	ALTIBASE HDB can store 16000bytes(UTF-16), 10666bytes(UTF-8) in NCHAR column. cf) ORACLE NCHAR max length : 2000
	NVARCHAR(n)	NVARCHAR(n)	ALTIBASE HDB can store 16000bytes(UTF-16), 10666(UTF-8) in NVARCHAR column. cf) ORACLE NVARCHAR max length : 2000
Long	LONG	CLOB	ALTIBASE HDB can store max 2G bytes in CLOB column.
	LONG RAW	BLOB	ALTIBASE HDB can store max 2G bytes in BLOB column.
	RAW	BLOB	ALTIBASE HDB can store max 2G bytes in BLOB column.
LOB	BLOB	BLOB	ALTIBASE can store max 2G bytes in BLOB column.
	CLOB	CLOB	ALTIBASE HDB can store max 2G bytes in CLOB column.
	NCLOB	Not supported 미지원
	BFILE	Not supported 미지원	Actually this data type is not supported in ALTIBASE HDB. But it can be replaced with BLOB in ALTIBASE HDB.
Numeric	NUMBER(p,s)	NUMBER(p,s)
	FLOAT(p)	FLOAT(p)
	BINARY_FLOAT	REAL	ALTIBAE HDB REAL type is equivalent to the float type in C Language.
	BIANRY_DOUBLE	DOUBLE	ALTIBAE HDB DOUBLE type is equivalent to the double type in C Language.
	NUMERIC(p,s)	NUMERIC(p,s)
	DECIMAL(p,s)	DECIMAL(p,s)
	INT	NUMBER(38)
	INTEGER	NUMBER(38)
	SMALLINT	NUMBER(38)
	FLOAT	FLOAT(38)	ORACLE FLOAT type is equivalent to FLOAT(126). But ALTIBASE HDB FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
	DOUBLE	FLOAT(38)	ORACLE FLOAT type is equivalent to FLOAT(126). But ALTIBASE HDB FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
	REAL	FLOAT(63)	ORACLE FLOAT type is equivalent to FLOAT(63). But ALTIBASE HDB FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
Date	DATE	DATE
	TIMESTAMP	미지원	TIMESTAMP data type in ALTIBASE HDB is different with ORACLE's timestamp although they appear to be same in a name. There is no data type corresponding ORACLE TIMESTAMP data type in ALTIBASE HDB, this type is only used by Replication Module. If you wish to get detailed value about date and time, we recomment you to use DATE data type instead even if there is degree of precision.
	INTERVAL YEAR TO MONTH	미지원
	INTERVAL DAY TO SECOND	미지원
ROWID	ROWID	미지원
	UROWID(n)	미지원

Category	ORACLE	ALTIBASE HDB	Description
Character	CHAR(n)	CHAR(n)	ALTIBASE HDB can store 32K characters in CHAR column. cf) ORACLE CHAR max length : 4000
	CHARACTER(n)	CHAR(n)
	VARCHAR(n)	VARCHAR (n)	ALTIBASE HDB can store 32K characters in VARCHAR column. cf) ORACLE VARCHAR max length : 4000
	VARCHAR2(n)	VARCHAR2(n)	ALTIBASE HDB can store 32K characters in VARCHAR2 column. cf) ORACLE VARCHAR2 max length : 4000
	NCHAR(n)	NCHAR(n)	ALTIBASE HDB can store 16000bytes(UTF-16), 10666(UTF-8) in NCHAR column. cf) ORACLE NCHAR max length : 2000
	NVARCHAR(n)	NVARCHAR(n)	ALTIBASE HDB can store 16000bytes(UTF-16), 10666(UTF-8) in NVARCHAR column. cf) ORACLE NCHAR max length : 2000
Long	LONG	CLOB	ALTIBASE HDB can store max 2G bytes in CLOB column.
	LONG RAW	BLOB	ALTIBASE HDB can store max 2G bytes in BLOB column.
	RAW	BLOB	ALTIBASE HDB can store max 2G bytes in BLOB column.
LOB	BLOB	BLOB	ALTIBASE HDB can store max 2G bytes in BLOB column.
	CLOB	CLOB	ALTIBASE HDB can store max 2G bytes in CLOB column.
	NCLOB	Not supported
	BFILE	Not supported	Actually this data type is not supported in ALTIBASE HDB. But it can be replaced with BLOB in ALTIBASE HDB.
Numeric	NUMBER(p,s)	NUMBER(p,s)
	FLOAT(p)	FLOAT(p)
	BINARY_FLOAT	REAL	ALTIBASE HDB REAL type is equivalent to the float type in C Language.
	BIANRY_DOUBLE	DOUBLE	ALTIBASE HDB DOUBLE type is equivalent to the double type in C Language.
	NUMERIC(p,s)	NUMERIC(p,s)
	DECIMAL(p,s)	DECIMAL(p,s)
	INT	NUMBER(38)
	INTEGER	NUMBER(38)
	SMALLINT	NUMBER(38)
	FLOAT	FLOAT(38)	ORACLE FLOAT type is equivalent FLOAT(126). But ALTIBASE FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
	DOUBLE	FLOAT(38)	ORACLE FLOAT type is equivalent FLOAT(126). But ALTIBASE FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
	REAL	FLOAT(63)	ORACLE FLOAT type is equivalent FLOAT(63). But ALTIBASE FLOAT type maximum precision is 38. So, if you want to change, it can be FLOAT(38).
Date	DATE	DATE
	TIMESTAMP	Not supported	TIMESTAMP data type in ALTIBASE HDB is different with ORACLE's TIMESTAMP although they appear to be same in a name. There is no data type corresponding ORACLE TIMESTAMP data type in ALTIBASE HDB. This type is only used by Replication Module. If you wish to get detailed value about date and time, we recomment you to use DATE data type instead even if there is degree of precision.
	INTERVAL YEAR TO MONTH	Not supported
	INTERVAL DAY TO SECOND	Not supported
ROWID	ROWID	Not supported
	UROWID(n)	Not supported

Icon

ALTIBASE HDB also has TIMESTAMP data type but it is totally different with ORACLE's.

It can be only used by the Replication module.

There is no way for user to access TIMESTAMP data type.

Do not use TIMESTAMP data type in ALTIBASE HDB, use DATE data type instead.

Overview

Data type Conversion Table