?
SQL?Server?和?Oracle?数据类型对应关系
?
当数据从SQL?Server?向?ORACLE?10g迁移时,可以做如下调整
SQL?SERVER | ORACLE |
bigint(8) | number(19) |
binary(50) | raw(50) |
bit(1) | number(2) |
char(10) | char(10) |
datetime(8) | date |
decimal(9) | number(18) |
float(8) | binary_double |
image(16) | blob |
int(4) | number(10) |
money(8) | number(19,4) |
nchar(10) | nchar(10) |
ntext(16) | nclob |
numeric(9) | number(18) |
nvarchar(50) | nvarchar2(50) |
real(4) | binary_float |
smalldatetime(4) | date |
smallint(2) | number(5) |
smallmoney(4) | number(10,4) |
sql_variant | blob |
text(16) | clob |
timestamp(8) | raw(8) |
tinyint(1) | number(3) |
uniqueidentifier(16) | blob |
varbinary(50) | raw(50) |
varchar(50) | varchar2(50) |
?