ADO 数据类型转换表

ADO DataType Enum	ADO DataType Enum Value	.NET Framework	SQL Server!	Size	Access文件	Oracle	Visual Basic 6.0
adBigInt	20	Int64 SqlDbType.BigInt¹⁰OleDbType.BigInt ¹¹	bigint ⁹	8			Variant
adBinary	128	Byte[] SqlDbType.VarBinary¹⁰OleDbType.Binary ¹¹	binary timestamp	50 8		Raw ⁷	Variant
adBoolean	11	Boolean SqlDbType.Bit¹⁰ OleDbType.Boolean ¹¹	bit	1 2	YesNo		Boolean
adBSTR	8	String OleDbType.BSTR ¹¹
adChapter	136	(DataReader)
adChar	129	String SqlDbType.Char¹⁰OleDbType.Char ¹¹	char	X		Char	String
adCurrency	6	Decimal SqlDbType.Money ¹⁰OleDbType.Currency ¹¹	money smallmoney	8 4 0	Currency		Currency
adDate	7	DateTime OleDbType.DBDate ¹¹		0	DateTime ²		Date
adDBDate	133	DateTime OleDbType.DBDate ¹¹
adDBFileTime	137	DBFileTime ¹¹
adDBTime	134	DateTime OleDbType.DBTime ¹¹
adDBTimeStamp	135	DateTime SqlDbType.DateTime¹⁰OleDbType.DBTimeStamp ¹¹	datetime smalldatetime	8 4 0	DateTime ¹	Date	Date
adDecimal	14	Decimal OleDbType.Decimal ¹¹				Decimal ⁷	Variant ⁶
adDouble	5	Double SqlDbType.Float¹⁰OleDbType.Double ¹¹	float	8 0	Double	Float	Double
adEmpty	0	Empty ¹¹
adError	10	External-Exception OleDbType.Error ¹¹
adFileTime	64	DateTime OleDbType.Filetime ¹¹
adGUID	72	Guid SqlDbType.UniqueIdentifier¹⁰OleDbType.Guid ¹¹	uniqueidentifier⁵	16	ReplicationID^2,3		Variant
adIDispatch	9	Object OleDbType.IDispatch ¹¹
adInteger	3	Int32 SqlDbType.Int¹⁰OleDbType.Integer ¹¹	identity ⁴ int	4 4	AutoNumber Long Integer	Int ⁷	Long
adIUnknown	13	Object OleDbType.IUnknown ¹¹
adLongVarBinary	205	Byte[] SqlDbType.VarBinary¹⁰OleDbType.LongVarBinary ¹¹	image	2147483647	OLEObject	Long Raw ⁷Blob ⁸	Variant
adLongVarChar	201	String SqlDbType.VarChar¹⁰OleDbType.LongVarChar ¹¹	text	2147483647	Memo ^{1, 2} Hyperlink ^{1, 2}	Long ⁷Clob ⁸	String
adLongVarWChar	203	String SqlDbType.NText¹⁰OleDbType.VarWChar ¹¹	ntext ⁵	1073741823	Memo ³ Hyperlink ³	NClob ⁸	String
adNumeric	131	Decimal SqlDbType.Decimal¹⁰OleDbType.Decimal ¹¹	decimal numeric	9	Decimal ³	Decimal Integer Number SmallInt	Variant ⁶
adPropVariant	138	Object OleDbType.PropVariant ¹¹
adSingle	4	Single SqlDbType.Real¹⁰OleDbType.Single ¹¹	real	4	Single		Single
adSmallInt	2	Int16, SqlDbType.SmallInt¹⁰OleDbType.SmallInt ¹¹	smallInt	2	Integer		Integer
adTinyInt	16	Byte OleDbType.TinyInt ¹¹
adUnsignedBigInt	21	UInt64 OleDbType.UnsignedBigInt ¹¹
adUnsignedInt	19	UInt32 OleDbType.UnsignedInt ¹¹
adUnsignedSmallInt	18	UInt16 OleDbType.UnsignedSmallInt ¹¹
adUnsignedTinyInt	17	Byte SqlDbType.TinyInt¹⁰OleDbType.UnsignedTinyInt ¹¹	tinyInt	1	Byte		Byte
adUserDefined	132
adVarBinary	204	Byte[] SqlDbType.VarBinary¹⁰OleDbType.VarBinary ¹¹	varbinary	50	ReplicationID ¹		Variant
adVarChar	200	String SqlDbType.VarChar¹⁰OleDbType.VarChar ¹¹	varchar	X	Text ^{1, 2}	VarChar	String
adVariant	12	Object SqlDbType.Variant¹⁰ OleDbType.Variant ¹¹	sql_variant ⁹	8016		VarChar2	Variant
adVarNumeric	139	OleDbType.VarNumeric ¹¹
adVarWChar	202	String SqlDbType.NVarChar¹⁰OleDbType.VarWChar ¹¹	nvarchar ⁵	X	Text ³	NVarChar2	String
adWChar	130	String SqlDbType.NChar¹⁰OleDbType.WChar ¹¹	nchar ⁵	X			String