ADO 数据类型转换表

netatomy

浏览: 46869 次
性别:
来自: 南京

最近访客更多访客>>

syht2000

woodding2008

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

ADO
DataType
EnumADO
DataType
Enum
Value.NET
FrameworkSQL
Server Size AccessOracleVisual
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

Top of Page

1 - ODBC Driver (3.51.171300): Microsoft Access Driver (*.mdb), Access 97 (3.5 format)
2 - OLE DB Provider: Microsoft.Jet.OLEDB.3.51, Access 97 (3.5 format)
3 - OLE DB Provider: Microsoft.Jet.OLEDB.4.0 , Access 2000 (4.0 format)
4 - OLE DB Provider: SQLOLEDB, SQL Server 6.5
5 - OLE DB Provider: SQLOLEDB, SQL Server 7.0+
6 - The VB Decimal data type can only be used within a Variant, that is, you cannot declare
a VB variable to be of type Decimal.
7 - Oracle 8.0.x Note: DECIMAL and INT are synonyms for NUMBER and NUMBER(10) respectively.
8 - Oracle 8.1.x
9 - OLE DB Provider: SQLOLEDB, SQL Server 2000 +
10 - SQL Server .NET Data Provider (via System.Data.SqlTypes)
11 - OLE DB .NET Data Provider (via System.Data.OleDb)