Data type mapping

Data Type Mapping

Mapping data types into different environments like .Net and SQL server.

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