Overview

This document provides guidance on compatibility and conversion details of data types when performing migration from Altibase to Tibero.

Method

Altibase				Tibero				Remarks
Type	Length	Precision	Scale	Type	Length	Precision	Scale
SMALLINT	2 Byte integer, same as C language short; Range: -32767 ~ 32767	X	X	NUMBER	X	5	0	Compatible SMALLINT - NUMBER(5,0)
BIGINT	8 Byte integer, same as C language long (64bit) Range: -9223372036854775807 ~ 9223372036854775807	X	X	NUMBER	X	19	0	Compatible BIGINT - NUMBER(19,0)
BLOB	Stores up to 2GB	X	X	BLOB	Stores up to 4GB	X	X	Compatible
CHAR	Up to 32000 Bytes	X	X	CHAR	Up to 2000 Bytes	X	X	Compatible Verify usage up to 200 bytes as-is
CLOB	Stores up to 2GB	X	X	CLOB	Stores up to 4GB	X	X	Compatible
DATE	X	X	X	DATE	X	X	X	Compatible
DOUBLE	8 Byte floating point, same data type as C language double	X	X	NUMBER	X	1 ~ 38	-125~130	Compatible DOUBLE - NUMBER
FLOAT	Floating point numeric data type ranging from -1E+120 to 1E+120	1 ~ 38	X	NUMBER	X	1 ~ 38	-125~130	Compatible FLOAT - NUMBER, FLOAT(10) - NUMBER
INTEGER	4 Byte integer; Range: -2,147,483,647 to 2,147,483,647	X	X	NUMBER	X	1 ~ 38	-125~130	Compatible INTEGER - NUMBER(10,0)
NUMERIC	Alias for NUMERIC data type However, if precision and scale are not specified, it is treated the same as FLOAT data type	1 ~ 38	-84 ~ 128	NUMBER	X	1 ~ 38	-125~130	Compatible
VARHAR	Up to 32000 Bytes			VARCHAR	Up to 65532 Bytes			Compatible

Altibase

Tibero

create table "TABLE_001"

(

"COL1" SMALLINT

"COL2" BIGINT,

"COL3" DOUBLE,

"COL4" FLOAT(10,2),

"COL5” FLOAT,

"COL6" INTEGER,

)

tablespace "UA_DISK_DATA"

pctfree 10

pctused 40;

create table "TABLE_001"

(

"COL1" NUMBER(5,0)

"COL2" NUMBER (19,0),

"COL3" NUMBER,

"COL4" NUMBER,

"COL5” NUMBER,

"COL6" NUMBER(10,0),

)

tablespace "UA_DISK_DATA"

pctfree 10

pctused 40;

Related to