Skip Headers
Oracle® Database Gateway for SQL Server User's Guide,
11g Release 2 (11.2)

Part Number E12069-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

A Data Type Conversion

This appendix contains the following section:

Data Type Conversion

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

Table A-1 Data Type Conversions

SQL Server Oracle Comment

BIGINT

NUMBER(20)

 

BIGINT IDENTITY

NUMBER(20)

 

BINARY

RAW

-

BIT

NUMBER(3)

-

CHAR

CHAR

-

DATETIME

DATE

Fractional parts of a second are truncated

DECIMAL

NUMBER(p[,s])

-

DECIMAL IDENTITY

NUMBER(p[,s])

 

FLOAT

FLOAT(53)

-

IMAGE

LONG RAW

-

INT

NUMBER(10)

 

INT IDENTITY

NUMBER(10)

 

MONEY

NUMBER(19,4)

-

NCHAR

NCHAR

if the size is 1000 or less. If the size is more than 1000, then it will be mapped to LONG Oracle Database Character Set = Unicode, otherwise, it is not supported.

NTEXT

LONG

if Oracle DB Character Set = Unicode. Otherwise, it is not supported

NVARCHAR

NVARCHAR

-

NVARCHAR(MAX)

LONG

if Oracle DB Character Set = Unicode. Otherwise, it is not supported

NUMERIC

NUMBER(p[,s])

-

NUMERIC IDENTITY

NUMBER(p[,s])

 

REAL

FLOAT(24)

-

SMALLDATETIME

DATE

-

SMALLMONEY

NUMBER(10,4)

-

SMALLINT

NUMBER(5)

-

SMALLINT IDENTITY

NUMBER(5)

 

SYSNAME

NVARCHAR

-

TEXT

LONG

 

TIMESTAMP

RAW

-

TINYINT

NUMBER(3)

-

TINYINT IDENTITY

NUMBER(3)

 

VARBINARY

RAW

-

VARBINARY(MAX)

LONG RAW

 

VARCHAR

VARCHAR2

-

VARCHAR(MAX)

LONG

-

XML

LONG

if Oracle Database Character Set = Unicode. Otherwise, it is not supported.