SQL Server与Oracle数据类型的对应关系
SQL Server与Oracle数据类型的对应关系SQL Server与Oracle数据类型的对应关系
| Oracle data type | SQL Server data type | Alternatives |
|---|---|---|
| BFILE | VARBINARY(MAX) | Yes |
| BLOB | VARBINARY(MAX) | Yes |
| CHAR([1-2000]) | CHAR([1-2000]) | Yes |
| CLOB | VARCHAR(MAX) | Yes |
| DATE | DATETIME | Yes |
| FLOAT | FLOAT | No |
| FLOAT([1-53]) | FLOAT([1-53]) | No |
| FLOAT([54-126]) | FLOAT | No |
| INT | NUMERIC(38) | Yes |
| INTERVAL | DATETIME | Yes |
| LONG | VARCHAR(MAX) | Yes |
| LONG RAW | IMAGE | Yes |
| NCHAR([1-1000]) | NCHAR([1-1000]) | No |
| NCLOB | NVARCHAR(MAX) | Yes |
| NUMBER | FLOAT | Yes |
| NUMBER([1-38]) | NUMERIC([1-38]) | No |
| NUMBER([0-38],[1-38]) | NUMERIC([0-38],[1-38]) | Yes |
| NVARCHAR2([1-2000]) | NVARCHAR([1-2000]) | No |
| RAW([1-2000]) | VARBINARY([1-2000]) | No |
| REAL | FLOAT | No |
| ROWID | CHAR(18) | No |
| TIMESTAMP | DATETIME | Yes |
| TIMESTAMP(0-7) | DATETIME | Yes |
| TIMESTAMP(8-9) | DATETIME | Yes |
| TIMESTAMP(0-7) WITH TIME ZONE | VARCHAR(37) | Yes |
| TIMESTAMP(8-9) WITH TIME ZONE | VARCHAR(37) | No |
| TIMESTAMP(0-7) WITH LOCAL TIME ZONE | VARCHAR(37) | Yes |
| TIMESTAMP(8-9) WITH LOCAL TIME ZONE | VARCHAR(37) | No |
| UROWID | CHAR(18) | No |
| VARCHAR2([1-4000]) | VARCHAR([1-4000]) | Yes |