Skip Headers

Oracle® Transparent Gateway for Microsoft SQL Server Administrator's Guide
10g Release 1 (10.1) for Microsoft Windows

Part Number B10544-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

A
Data Type Conversion

This appendix contains the following section:

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

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)

-

VARBINARY

RAW

-

VARCHAR

VARCHAR2

-


Go to previous page Go to next page
Oracle
Copyright © 2002, 2004, Oracle.

All rights reserved.
Go To Table Of Contents
Contents
Go To Index
Index