首页 / 数据库 / 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 |
|
|
易网时代-编程资源站