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
MYSQL、SQLServer以及ORACLE数据类型之间转换对应
最新推荐文章于 2024-06-11 10:10:34 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)