ADO数据类型参照

上一篇 / 下一篇 2007-01-15 13:13:55 / 个人分类：IT技术

ADO DataType Enum	ADO DataType Enum Value	.NET Framework	Visual Basic 6.0	Access	SQL Server	Oracle
adBigInt	20	Int64 SqlInt64 BigInt	Variant		BigInt
adBinary	128	Byte[] SqlBinary Binary	Variant		Binary TimeStamp	Raw
adBoolean	11	Boolean SqlBoolean Boolean	Boolean	YesNo	Bit
adBSTR	8	String BSTR
adChapter	136	(DataReader)
adChar	129	String SqlString Char	String		Char	Char
adCurrency	6	Decimal SqlMoney Currency	Currency	Currency	Money SmallMoney
adDate	7	DateTime Date	Date	DateTime
adDBDate	133	DateTime DBDate
adDBFileTime	137	DBFileTime
adDBTime	134	DateTime DBTime
adDBTimeStamp	135	DateTime SqlDateTime DBTimeStamp	Date	DateTime	Datetime SmallDateTime	Date
adDecimal	14	Decimal Decimal	Variant			Decimal
adDouble	5	Double SqlDouble Double	Double	Double	Float	Float
adEmpty	0	Empty
adError	10	External-Exception Error
adFileTime	64	DateTime Filetime
adGUID	72	Guid SqlGuid Guid	Variant	ReplicationID	UniqueIdentifier
adIDispatch	9	Object IDispatch
adInteger	3	Int32 SqlInt32 Integer	Long	AutoNumber Integer Long	Identity Int	Int
adIUnknown	13	Object IUnknown
adLongVarBinary	205	Byte[] SqlBinary LongVarBinary	Variant	OLEObject	Image	Long Raw Blob
adLongVarChar	201	String SqlString LongVarChar	String	Memo Hyperlink	Text	Long Clob
adLongVarWChar	203	String SqlString LongVarWChar	String	Memo Hyperlink	NText	NClob
adNumeric	131	Decimal SqlDecimal Numeric	Variant	Decimal	Decimal Numeric	Decimal Integer Number SmallInt
adPropVariant	138	Object PropVariant
adSingle	4	Single SqlSingle SIngle	Single	Single	Real
adSmallInt	2	Int16, SqlInt16 SmallInt	Integer	Integer	SmallInt
adTinyInt	16	Byte TinyInt
adUnsignedBigInt	21	UInt64 UnsignedBigInt
adUnsignedInt	19	UInt32 UnsignedInt
adUnsignedSmallInt	18	UInt16 UnsignedSmallInt
adUnsignedTinyInt	17	Byte SqlByte UnsignedTinyInt	Byte	Byte	TinyInt
adUserDefined	132
adVarBinary	204	Byte[] SqlBinary VarBinary	Variant	ReplicationID	VarBinary
adVarChar	200	String SqlString VarChar	String	Text	VarChar	VarChar
adVariant	12	Object Variant	Variant		Sql_Variant	VarChar2
adVarNumeric	139	VarNumeric
adVarWChar	202	String SqlString VarWChar	String	Text	NVarChar	NVarChar2
adWChar	130	String SqlString WChar	String		NChar