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