Data types

This section explains the comparison of column data types between Tibero and other DBMS.

ORACLE

The following is a comparison of data types between Oracle and Tibero.

Oracle	Tibero
CHAR	CHAR
VARCHAR	VARCHAR
VARCHAR2	VARCHAR2 (It is created as VARCHAR internally but functions the same as Oracle's VARCHAR2)
NCHAR	NCHAR
NVARCHAR	NVARCHAR
NVARCHAR2	NVARCHAR2 (It is created as NVARCHAR internally but functions the same as Oracle's NVARCHAR2)
BLOB	BLOB
CLOB	CLOB
NCLOB	NCLOB
LONG	LONG
NUMBER	NUMBER
NUMERIC	NUMERIC (It is created as NUMBER internally)
INT	INT (It is created as NUMBER internally)
DECIMAL	DECIMAL (It is created as NUMBER internally)
DOUBLE	NUMBER
FLOAT	FLOAT (It is created as NUMBER internally)
REAL	REAL (It is created as NUMBER internally)
SMALLINT	SMALLINT (It is created as NUMBER internally)
BINARY_FLOAT	NUMBER
BINARY_DOUBLE	NUMBER
DATE	DATE
TIMESTAMP	TIMESTAMP
BFILE	Tibero does not support BFILE, so bypass by using BLOB
RAW	RAW
LONG RAW	LONG RAW
XMLTYPE	XMLTYPE (Syntax changes are required as the creation syntax differs slightly: Oracle uses SYS.XMLTYPE, while Tibero uses XMLTYPE) Oracle : SYS.XMLTYPE, Tibero : XMLTYPE)
GEOMETRY	GEOMETRY

---

MS-SQL

The following is a comparison of data types between MS-SQL and Tibero.

MS-SQL	Tibero
VARCHAR(MAX)	CLOB
NVARCHAR(MAX)	NCLOB
VARBINARY(MAX)	BLOB
UNIQUEIDENTIFIER	VARCHAR
SQL_VARIANT LONG	RAW
BIGINT	NUMBER
NTEXT	CLOB

---

Sybase

The following is a comparison of data types between Sybase and Tibero.

Sybase	Tibero
TINYINT NUMBER	NUMBER
SMALLINT NUMBER	NUMBER
INT NUMBER	NUMBER
NUMERIC(P,S)	NUMBER(n,n)
DECIMAL(P,S)	NUMBER(n,n)
FLOAT(PRECISION)	NUMBER
DOUBLE(PRECISION)	NUMBER
REAL NUMBER	NUMBER
SMALLMONEY	NUMBER(10,4)
MONEY	NUMBER(19,4)
SMALLDATETIME	DATE or TIMESTAMP
DATETIME	DATE or TIMESTAMP
CHAR(N)	CHAR(N)
VARCHAR(N)	VARCHAR(N)
UNICHAR(N)	NCHAR(N)
UNIVARCHAR(N)	NVARCHAR(N)
NCHAR(N)	NCHAR(N)
NVARCHAR(N)	NVARCHAR(N)
BINARY(N)	CLOB
VARBINARY(N)	BLOB
BIT	NUMBER(1) or CHAR(1)
TEXT CLOB	CLOB
IMAGE	BLOB