Sqlserver mysql oracle
INT INT NUMBER
TINYINT TINYINT NUMBER
SMALLINT INT NUMBER
BIGINT BIGINT NUMBER
BIT BIT NUMBER
DATETIME DATETIME DATE
DATE DATE DATE
DATETIME DATETIME DATETIME
DATETIME2(7) DATETIME DATE
TIME(7) DATETIME DATE
IMAGE MEDIUMBLOB BLOB
TEXT MEDIUMTEXT CLOB
DECIMAL(5,2) DECIMAL(5,2) NUMBER(5,2)
FLOAT FLOAT NUMBER
MONEY VARCHAR(20) VARCHAR2(40)
NCHAR(30) NCHAR(30) NCHAR(30)
NVARCHAR(30) NVARCHAR(30) NVARCHAR2(60)
VARCHAR VARCHAR(20) VARCHAR2(40)
VARCHAR(20) VARCHAR(20) VARCHAR2(40)
CHAR(10) CHAR(10) VARCHAR2(20)
XML VARCHAR(4000) VARCHAR2(4000)
mysql和sqlserver和oracle对比
最新推荐文章于 2024-04-05 08:59:19 发布