Delphi与各数据库数据类型比较

EnableFMTBCD is True - uses ftFMTBCD;
uses ftFloat.
[4] - If the EnableBoolean option is True
[5] - If the RawAsString option is True
[6] - If the BinaryAsString is True
if scale equals zero, provider checks values of the specific options to choose the correct Delphi type in the following order:
1.1 field precision is less or equal Precision Smallint (default is 4) - uses ftSmallint; 1.2 field precision is less or equal Precision Integer (default is 9) - uses ftInteger; 1.3 field precision is less or equal Precision LargeInt (default is 18) - uses ftLargeint;
-
DECIMAL(p, s)[3] FLOAT REAL
DECIMAL(p, s)[3] (p < 15) and (s < 5) DECIMAL(p, s) (14 < p < 39) and (4 < s < 39) MONEY SMALLMONEY
MySQL Types [1] TINYINT(M) (M > 1) SMALLINT TINYINT(M) UNSIGNED (M > 1) SMALLINT UNSIGNED YEAR MEDIUMINT MEDIUMINT UNSIGNED INT BIT INT UNSIGNED BIGINT BIGINT UNSIGNED
if scale is greater than zero, the appropriate Delphi type is chosen using the following sequence of rules:.
2.1 field precision is less or equal PrecisionFloat (default is 0) - uses ftFloat; 2.2 EnableBCD is True and field precision, scale is less or equal PrecisionBCD (default is 14,4) - uses ftBCD; 2.3 EnableFMTBCD is True and field precision, scale is less or equal PrecisionFMTBCD (default is 38,38) - uses ftFMTBCD; 2.4 uses ftFloat.
[3] - The appropriate Delphi type is chosen using the following sequence of rules:
EnableBCD is True and field precision, scale is less or equal 14,4 - uses ftBCD;
VARBINARY
ftDate ftDateTime ftTime
ftTimeStamp
-
DATE
TIMESTAMP TIMESTAMP TIMEZONE
DATE -
WITH -
DATE DATETIME TIME
-
ftCursor ftGuid ftVariant
REF CURIDENTIFIER -
-
SQL Server Types SMALLINT
TINYINT
NUMBER(p, 0)[2] INT
(4 < p < 10)
NUMBER(p, 0)[2] (9 < p < 19)
BIGINT
NUMBER(p, s)[2] BINARY FLOAT(FLOAT) BINARY DOUBLE
NUMBER(p, s)[2] (p < 15) and (s < 5) NUMBER(p, s)[2] (14 < p < 39) and> (4 < s < 39)
ROWID UROWID
See note [7]
ftMemo
ftWideMemo ftOraClob
LONG Also see note [8]
See note[10] CLOB NCLOB
ftBlob
ftOraBlob ftBytes ftVarBytes
LONG RAW
BLOB RAW
NCHAR NVARCHAR TEXT NTEXT[9] NTEXT[11] -
ftString
VARCHAR2
NVARCHAR2
VARCHAR
CHAR
CHAR
NCHAR
VARCHAR
RAW[5]
INTERVAL DAY TO SECOND
INTERVAL DAY TO MONTH
CHAR VARCHAR ENUM SET BINARY[6] VARBINARY[6]
ftWideString
[11] - For BDS 2006 and higher IDE versions.
DECIMAL(p, s)[3] FLOAT DOUBLE
DECIMAL(p, s)[3] (p < 15) and (s < 5) DECIMAL(p, s)[3] (14 < p < 39) and (4 < s < 39)
-
ftBoolean
-
TINYINT[4]
BIT
BOOL[4]
BOOLEAN[4]
[9] - For all Delphi versions prior to BDS 2006.
[10] - If the UseUnicode option is True, in BDS 2006 and later versions all server types mapped to ftMemo will be mapped to ftWideMemo.
SQL_VARIANT
-
BFILE NOT SUPPORTED OBJECT
XML
CURSOR
XML
-
TABLE
[1] – 如果 FieldsAsString 选项被设置 True，则除 BLOB 和 TEXT 数据类型外，全部做为 ftString 来处理
[2] – Oracle NUMBER 数据类型与 Delphi 数据类型对应方式:
[7] - If the UseUnicode option is True, all server types mapped to ftString will be mapped to ftWideString.
[8] - If the LongStrings option is False, and the field length is greater than 255, all server types mapped to ftString will be mapped to ftMemo.
Delphi 与各数据库数据类型比较
Delphi 数据类型与各数据库数据类型对比如下表，如有具体说明见表中脚注：
Delphi Type ftSmallint ftWord ftInteger ftLargeint
ftFloat ftBCD ftFMTBcd ftCurrency
Oracle Types NUMBER(p, 0)[2] (p < 5)
IMAGE
BINARY TIMESTAMP VARBINARY
See note [7]
TINYTEXT TEXT MEDIUMTEXT LONGTEXT See note[10]
-
TINYBLOB BLOB MEDIUMBLOB LONGBLOB Spatial Data Types -
BINARY