ADO 数据类型转换表 oledbtype sqldbtype (二)

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

相关阅读:
【SpringBoot学习笔记】无法解析parent POM——1.5.3.RELEASE
【WPF学习日记——[DevExpress]】GridControl 行中使用按钮
【Web学习日记】——C#引用WebService，从配置文件改变引用地址
【Web学习日记】——在IIS上发布一个WebService
【WPF学习日记】——Window的DataContext绑定ViewModel
使用kubectl管理k8s集群
使用Kubeadm创建k8s集群之节点部署
使用Kubeadm创建k8s集群之部署规划
kubernetes运维
linux常用命令大全

原文地址：https://www.cnblogs.com/xryyforver/p/1508846.html