-
Notifications
You must be signed in to change notification settings - Fork 2
converter oracle mapping
wz2cool edited this page May 6, 2019
·
2 revisions
| Mysql | oracle | comment |
|---|---|---|
| BIT | NUMBER | |
| TINYINT | NUMBER | |
| SMALLINT | NUMBER | |
| MEDIUMINT | NUMBER | |
| INT | NUMBER | |
| INTEGER | NUMBER | |
| BIGINT | NUMBER | |
| FLOAT | FLOAT | |
| DOUBLE | FLOAT | |
| DECIMAL | FLOAT | |
| DATE | DATE | |
| DATETIME | DATE | |
| TIMESTAMP | DATE | |
| TIME | VARCHAR2 | 无 TIME 类型 |
| VARCHAR | NVARCHAR2 | |
| CHAR | NVARCHAR2 | |
| TINYBLOB | BLOB | |
| BLOB | BLOB | |
| MEDIUMBLOB | BLOB | |
| LONGBLOB | BLOB | |
| TINYTEXT | NCLOB | |
| TEXT | NCLOB | |
| MEDIUMTEXT | NCLOB | |
| LONGTEXT | NCLOB |