SQL Server 和Oracle 数据类型对应

来源：互联网发布：大富豪3.29源码编辑：程序博客网时间：2024/06/05 00:07

SqlServer 2k转换为Oracle 10g

列名SqlServer数据类型SqlServer长度Oracle数据类型column1bigint8 NUMBER(19)column2binary50 RAW(50)column3bit1 NUMBER(2)column4char10 CHAR(10)column5datetime8 DATEcolumn6decimal9 NUMBER(18)column7float8BINARY_DOUBLEcolumn8image16 BLOBcolumn9int4 NUMBER(10)column10money8 NUMBER(19,4)column11nchar10 NCHAR(10)column12ntext16 NCLOBcolumn13numeric9NUMBER(18)column14nvarchar50NVARCHAR2(50)column15real4BINARY_FLOATcolumn16smalldatetime4DATEcolumn17smallint2NUMBER(5)column18smallmoney4NUMBER(10,4)column19sql_variant BLOBcolumn20text16CLOBcolumn21timestamp8RAW(8)column22tinyint1NUMBER(3)column23uniqueidentifier16BLOBcolumn24varbinary50RAW(50)column25varchar50VARCHAR2(50)

Oracle 10g 转换为SqlServer 2k

Oracle列名Oracle数据类型SqlServer列名SqlServer数据类型SqlServer数据长度COLUMN1BINARY_DOUBLECOLUMN1float8COLUMN2BINARY_FLOATCOLUMN2real4COLUMN3BLOBCOLUMN3image16COLUMN4CLOBCOLUMN4ntext16COLUMN5CHAR(10)COLUMN5nchar10COLUMN6DATECOLUMN6datetime8COLUMN12NUMBERCOLUMN12numeric13COLUMN13NVARCHAR2(10)COLUMN13nvarchar10COLUMN14RAW(10)COLUMN14varbinary10COLUMN15TIMESTAMP(6)COLUMN15datetime8COLUMN16TIMESTAMP(6) WITH LOCAL TIME ZONECOLUMN16datetime8COLUMN17TIMESTAMP(6) WITH TIME ZONECOLUMN17datetime8COLUMN18VARCHAR2(10)COLUMN18nvarchar10COLUMN7INTERVAL DAY(2) TO SECOND(6)COLUMN7nvarchar30COLUMN8INTERVAL YEAR(2) TO MONTHCOLUMN8nvarchar14COLUMN9LONGCOLUMN9ntext16COLUMN10LONG RAWCOLUMN10image16COLUMN11NCLOBCOLUMN11ntext16