CHAR
CHAR data type can be used in storing fixed-length characters having maximum value in ORACLE.
It is same in ALTIBASE except the maximum length of CHAR data type.
ORACLE can store maximum 2000 bytes.
And ALTIBASE HDB can contain maximum 32K bytes in VARCHAR data type.
Also, ALTIBASE HDB does not support CHAR qualifier for column length. (only support BYTE)
VARCHAR
VARCHAR data type can be used in storing variable-length characters having maximum value in ORACLE.
It is same in ALTIBASE except the maximum length of VARCHAR data type.
ORACLE can store maximum 4000 bytes.
And ALTIBASE HDB can contain maximum 32K bytes in VARCHAR data type.
Also, ALTIBASE HDB does not support CHAR qualifier for column length. (only support BYTE)
VARCHAR2 (size)
As ORACLE treats VARCHAR and VARCHAR2 data type identical, ALTIBASE HDB does as well.
NCHAR (size)
NCHAR data type is a Unicode-only data type with fixed length.
ORACLE can store maximum 2000 bytes in NCHAR type.
And ALTIBASE HDB can contain maximum 32K.
The maximum length of a column is determined by the national character set definition.
And when a national character set is defined as UTF16, ALTIBASE HDB can accommodate up to 16000 bytes.
In case of UTF8, It can store up to 10,666 bytes.
NVARCHAR (size)
NVARCHAR data type is a Unicode-only data type with variable length.
ORACLE can store maximum 4000 bytes in NVARCHAR type.
And ALTIBASE HDB can contain maximum 32K.
The maximum length of a column is determined by the national character set definition.
LONG
LONG data type can be used in storing up to 2GB bytes in ORACLE.
You can convert LONG data type in ORACLE to CLOB data type in ALTIBASE HDB.
LONG columns store variable-length character strings containing up to 2 gigabytes.
This type can be replaced with CLOB in ALTIBASE HDB.
LONG RAW
LONG RAW columns store variable-length binary data containing up to 2 gigabytes.
This type can be replaced with BLOB in ALTIBASE HDB.
It can contain up to 2GB in ALTIBASE HDB.
RAW
RAW columns store variable-length binary data containing up to 2000 bytes in ORACLE.
This type can be replaced with BYTE in ALTIBASE HDB.
The maximum length of BYTE type in ALTIBASE HDB is 32000 bytes.