2023年7月13日发(作者：)

SQLServer和Oracle数据类型对应

SqlServer 2k转换为Oracle 10g

列名SqlServer数据类型SqlServer长度column1bigint8column2binary50column3bit1column4char10column5datetime8column6decimal9column7float8column8image16column9int4column10money8column11nchar10column12ntext16column13numeric9column14nvarchar50column15real4column16smalldatetime4column17smallint2column18smallmoney4column19sql_variant

column20text16column21timestamp8column22tinyint1column23uniqueidentifier16column24varbinary50column25varchar50

Oracle 10g 转换为SqlServer 2k

Oracle列名Oracle数据类型COLUMN1BINARY_DOUBLECOLUMN2BINARY_FLOATCOLUMN3BLOBCOLUMN4CLOBCOLUMN5CHAR(10)COLUMN6DATECOLUMN12NUMBERCOLUMN13NVARCHAR2(10)COLUMN14RAW(10)COLUMN15TIMESTAMP(6)COLUMN16TIMESTAMP(6) WITH LOCAL TIMEZONECOLUMN17TIMESTAMP(6) WITH TIME ZONECOLUMN18VARCHAR2(10)COLUMN7INTERVAL DAY(2) TO SECOND(6)COLUMN8INTERVAL YEAR(2) TO MONTHCOLUMN9LONGCOLUMN10LONG RAWCOLUMN11NCLOBOracle数据类型NUMBER(19)RAW(50)NUMBER(2)CHAR(10)DATENUMBER(18)BINARY_DOUBLEBLOBNUMBER(10)NUMBER(19,4)NCHAR(10)NCLOBNUMBER(18)NVARCHAR2(50)BINARY_FLOATDATENUMBER(5)NUMBER(10,4)BLOBCLOBRAW(8)NUMBER(3)BLOBRAW(50)VARCHAR2(50)SqlServer列名SqlServer数据类型COLUMN1floatCOLUMN2realCOLUMN3imageCOLUMN4ntextCOLUMN5ncharCOLUMN6datetimeCOLUMN12numericCOLUMN13nvarcharCOLUMN14varbinaryCOLUMN15datetimeCOLUMN16datetimeCOLUMN17datetimeCOLUMN18nvarcharCOLUMN7nvarcharCOLUMN8nvarcharCOLUMN9ntextCOLUMN10imageCOLUMN11ntextSqlServer数据长度8416161