> For the complete documentation index, see [llms.txt](https://docs.tibero.com/en_tibero-technical-guides/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/en_tibero-technical-guides/getting-started/migration/data-types.md).

# 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.

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

###

***

## MS-SQL<br>

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

<table><thead><tr><th width="306">MS-SQL</th><th>Tibero</th></tr></thead><tbody><tr><td>VARCHAR(MAX)</td><td>CLOB</td></tr><tr><td>NVARCHAR(MAX)</td><td>NCLOB</td></tr><tr><td>VARBINARY(MAX)</td><td>BLOB</td></tr><tr><td>UNIQUEIDENTIFIER</td><td>VARCHAR</td></tr><tr><td>SQL_VARIANT LONG</td><td>RAW</td></tr><tr><td>BIGINT</td><td>NUMBER</td></tr><tr><td>NTEXT</td><td>CLOB</td></tr></tbody></table>

###

***

## Sybase<br>

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

<table><thead><tr><th width="319">Sybase</th><th>Tibero</th></tr></thead><tbody><tr><td>TINYINT NUMBER</td><td>NUMBER</td></tr><tr><td>SMALLINT NUMBER</td><td>NUMBER</td></tr><tr><td>INT NUMBER</td><td>NUMBER</td></tr><tr><td>NUMERIC(P,S)</td><td>NUMBER(n,n)</td></tr><tr><td>DECIMAL(P,S)</td><td>NUMBER(n,n)</td></tr><tr><td>FLOAT(PRECISION)</td><td>NUMBER</td></tr><tr><td>DOUBLE(PRECISION)</td><td>NUMBER</td></tr><tr><td>REAL NUMBER</td><td>NUMBER</td></tr><tr><td>SMALLMONEY</td><td>NUMBER(10,4)</td></tr><tr><td>MONEY</td><td>NUMBER(19,4)</td></tr><tr><td>SMALLDATETIME</td><td>DATE or TIMESTAMP</td></tr><tr><td>DATETIME</td><td>DATE or TIMESTAMP</td></tr><tr><td>CHAR(N)</td><td>CHAR(N)</td></tr><tr><td>VARCHAR(N)</td><td>VARCHAR(N)</td></tr><tr><td>UNICHAR(N)</td><td>NCHAR(N)</td></tr><tr><td>UNIVARCHAR(N)</td><td>NVARCHAR(N)</td></tr><tr><td>NCHAR(N)</td><td>NCHAR(N)</td></tr><tr><td>NVARCHAR(N)</td><td>NVARCHAR(N)</td></tr><tr><td>BINARY(N)</td><td>CLOB</td></tr><tr><td>VARBINARY(N)</td><td>BLOB</td></tr><tr><td>BIT</td><td>NUMBER(1) or CHAR(1)</td></tr><tr><td>TEXT CLOB</td><td>CLOB</td></tr><tr><td>IMAGE</td><td>BLOB</td></tr></tbody></table>

###