Ea-Technology

‹ previous next ›

Data Type Conversion

Data Type Conversion

The gateway converts Microsoft SQL Server data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Microsoft SQL Server Oracle Comment
BIGINT NUMBER(19)
BINARY RAW –
BIT NUMBER(3) –
CHAR CHAR –
DATETIME DATE Fractional parts of a second are truncated
DECIMAL NUMBER(p[,s]) –
FLOAT FLOAT(49) –
IMAGE LONG RAW –
INTEGER NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647
MONEY NUMBER(19,4) –
NCHAR NCHAR –
NTEXT LONG –
NVARCHAR NCHAR –
NUMERIC NUMBER(p[,s]) –
REAL FLOAT(23) –
SMALL DATETIME DATE The value for seconds is returned as 0
SMALL MONEY NUMBER(10,4) –
SMALLINT NUMBER(5) NUMBER range is -32,767 to 32,767
TEXT LONG –
TIMESTAMP RAW –
TINYINT NUMBER(3) –
UNIQUEIDENTIFIER CHAR(36)
VARBINARY RAW –
VARCHAR VARCHAR2 –

Free Web Hosting