Delphi字段类型和不同数据库对应.txt

DELPHI-->Ora
ftFloat:8--BINARY_DOUBLE
ftSingle:4--BINARY_FLOAT
ftOraBlob:0--BLOB
ftOraClob:0--CLOB
ftString:2--CHAR(1)
ftDateTime:8--DATE
ftOraInterval:0--INTERVAL DAY(2) TO SECOND(6)
ftOraInterval:0--INTERVAL YEAR(2) TO MONTH
ftMemo:0--LONG
ftWideMemo:0--NCLOB
ftFMTBcd:34--NUMBER
ftWideString:22--NVARCHAR2(10)
ftVarBytes:12--RAW(10)
ftTimeStamp:16--TIMESTAMP(6)
ftTimeStamp:16--TIMESTAMP(6) WITH LOCAL TIME ZONE
ftTimeStamp:16--TIMESTAMP(6) WITH TIME ZONE
ftString:11--VARCHAR2(10)

 

DELPHI-->MSSQL
ftLargeint:8--bigint
ftBytes:50--binary(50)
ftBoolean:2--bit
ftString:11--char(10)
ftDate:4--date
ftTimeStamp:16--datetime
ftTimeStamp:16--datetime2(7)
ftString:2--datetimeoffset(7)
ftBCD:34--decimal(18, 0)
ftFloat:8--float
ftString:2--geography
ftString:2--geometry
ftString:2--hierarchyid
ftBlob:0--image
ftInteger:4--int
ftCurrency:8--money
ftWideString:22--nchar(10)
ftWideMemo:0--ntext
ftBCD:34--numeric(18, 0)
ftWideString:102--nvarchar(50)
ftSingle:4--real
ftTimeStamp:16--smalldatetime
ftSmallint:2--smallint
ftCurrency:8--smallmoney
ftWideString:16002--sql_variant
ftMemo:0--text
ftTime:4--time(7)
ftBytes:8--timestamp
ftByte:1--tinyint
ftGuid:39--uniqueidentifier
ftVarBytes:52--varbinary(50)
ftString:51--varchar(50)
ftDBaseOle:0--xml