【数据库】MYSQL、SQLServer以及ORACLE数据类型之间转换对应

                    MYSQL、SQLServer以及ORACLE数据类型之间转换对应

MYSQL数据库	SQLServer数据库	ORACLE数据库
TINYINT	bit	CHAR
SMALLINT	tinyint	VARCHAR2
MEDIUMINT	smallint	NCHAR
INT	int	NVARCHAR2
INTEGER	bigint	DATE
BIGINT	decimal	LONG
FLOAT	numeric	RAW
DOUBLE	smallmoney	LONG RAW
DOUBLE PRECISION	money	BLOB
REAL	float	CLOB
DECIMAL	real	NCLOB
NUMERIC	Smalldatetime	BFILE
DATE	datetime	ROWID
DATETIME	cursor	NROWID
TIMESTAMP	timestamp	NUMBER
TIME	Uniqueidentifier	DECIMAL
YEAR	char	INTEGER
CHAR	varchar	FLOAT
VARCHAR	text	REAL
TINYBLOB	nchar	timestamp
TINYTEXT	nvarchar
BLOB	ntext
TEXT	binary
MEDIUMBLOB	varbinary
MEDIUMTEXT	image
LONGBLOB
LONGTEXT
ENUM
SET