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

Delphi与各数据库数据类型比较 Delphi数据类型与各数据库数据类型对比如下表，如有具体说明见表中脚注： Delphi Type Oracle Types SQL Server Types MySQL Types [1] InterBase Types PostgreSQL Types SQLite Types ftSmallint NUMBER(p, 0)[2](p 5) SMALLINT TINYINT(M) (M 1)SMALLINT SMALLINT SMALLINT TINYINTSMALLINT ftWord - TINYINT TINYINT(M) UNSIGNED (M 1)SMALLINT UNSIGNEDYEAR - - - ftInteger NUMBER(p, 0)[2](4 p 10) INT MEDIUMINTMEDIUMINT UNSIGNEDINT INTEGER INTEGER INTEGERINT ftLargeint NUMBER(p, 0)[2](9 p 19) BIGINT BITINT UNSIGNEDBIGINTBIGINT UNSIGNED BIGINT BIGINT BIGINT ftFloat NUMBER(p, s)[2]BINARY FLOAT(FLOAT)BINARY DOUBLE DECIMAL(p, s)[3]FLOATREAL DECIMAL(p, s)[3]FLOATDOUBLE NUMBER(p, s)[3]FLOATDOUBLE PRECISION DECIMAL[3]REALDOUBLE PRECISION DECIMAL(p, s)[3]FLOATDOUBLE PRECISION ftBCD NUMBER(p, s)[2](p 15) and (s 5) DECIMAL(p, s)[3](p 15) and (s 5) DECIMAL(p, s)[3](p 15) and (s 5) DECIMAL(p, s)[3](p 15) and (s 5) DECIMAL[3] DECIMAL[3] ftFMTBcd NUMBER(p, s)[2](14 p 39) and(4 s 39) DECIMAL(p, s)(14 p 39) and(4 s 39) DECIMAL(p, s)[3](14 p 39) and(4 s 39) DECIMAL(p, s)[3](14 p 19) and(4 s 19) DECIMAL[3] DECIMAL[3] ftCurrency - MONEYSMALLMONEY - - MONEY MONEY ftBoolean - BIT TINYINT[4]BOOL[4]BOOLEAN[4] BOOLEAN BOOLEAN BOOLEAN ftString VARCHAR2NVARCHAR2VARCHARCHARNCHARRAW[5]INTERVAL DAY TO SECONDINTERVAL DAY TO MONTHROWIDUROWID CHARVARCHAR CHARVARCHARENUMSETBINARY[6]VARBINARY[6] CHARVARCHAR CHARVARCHAR CHARVARCHAR ftWideString See note [7] NCHARNVARCHAR See note [7] See note [7] See note [7] See note [7] ftMemo LONGAlso see note [8] TEXTNTEXT[9] TINYTEXTTEXTMEDIUMTEXTLONGTEXT BLOB TEXT TEXT TEXTCLOB ftWideMemo See note[10] NTEXT[11] See note[10] See note[10] See note[10] See note[10] ftOraClob CLOBNCLOB - - - - - ftBlob LONG RAW IMAGE TINYBLOBBLOBMEDIUMBLOBLONGBLOBSpatial Data Types BLOB BINARY BYTEA BLOB ftOraBlob BLOB - - - LARGE OBJECT - ftBytes - BINARYTIMESTAMP BINARY - - - ftVarBytes RAW V