Skip Headers
Oracle® Transparent Gateway for Microsoft SQL Server Administrator's Guide
10g Release 2 (10.2) for Microsoft Windows (32-bit)

Part Number B14270-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
View PDF

A Data Type Conversion

This appendix contains the following section:

A.1 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 -