Oracle和sqlserver資料型別對應

走在Bug的路上發表於2018-08-15
Sqlserver型別 Oracle型別
binary     RAW(50)
bit     NUMBER(2)
char     CHAR(10)
datetime     DATE
decimal     NUMBER(18)
float  BINARY_DOUBLE
image     BLOB
int     NUMBER(10)
money   NUMBER(19,4)
nchar   NCHAR(10)
ntext   NCLOB
numeric  NUMBER(18)
nvarchar  NVARCHAR2(50)
real  BINARY_FLOAT
smalldatetime  DATE
smallint  NUMBER(5)
smallmoney  NUMBER(10,4)
sql_variant  BLOB
text  CLOB
timestamp  RAW(8)
tinyint  NUMBER(3)
uniqueidentifier  BLOB
varbinary  RAW(50)
varchar  VARCHAR2(50)

相關文章