MSSQL to Oracle 이관시 데이터 타입 변환정리

Transparent Gateway for Microsoft SQL Server(TG4MSQL) 에서 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	-