SQL Server 与 Oracle数据类型映射

SQL Server与Oracle数据库比较

转载于 2015-08-18 08:52:04 发布 · 1k 阅读

16 篇文章

订阅专栏

11 篇文章

订阅专栏

本文对比了Microsoft SQL Server和Oracle数据库的特点、功能和应用场景，包括数据类型、性能指标、安全性等方面，帮助开发者选择合适的数据库。

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	-