Wednesday, March 13, 2013

Oracle vs SQL Server Datatype Mapping


SQL Server Data Type       Oracle Data Type

VARCHAR                    VARCHAR2

MONEY                      NUMBER(19,4)

BIT                        NUMBER(1,0)

IMAGE                      BLOB

SYSNAME                    VARCHAR2(128)

VARCHAR(MAX)               CLOB

DATETIME                   TIMESTAMP(3)

DECIMAL                    NUMBER

TINYINT                    NUMBER(3,0)

FLOAT                      NUMBER

CHAR                       CHAR

UNIQUEIDENTIFIER           CHAR(36)

BIGINT                     NUMBER(10,0)

INT                        NUMBER(10,0)

NUMBERIC                   NUMBER

NVARCHAR(MAX)              NCLOB

SMALLMONEY                 NUMBER(10,4)

NVARCHAR                   NVARCHAR2

TEXT                       CLOB
 

No comments:

Post a Comment