Microsoft ADO.NET 与 Oracle ODP.NET

最新推荐文章于 2026-06-06 16:05:25 发布

原创最新推荐文章于 2026-06-06 16:05:25 发布 · 1.9k 阅读

本内容遵循CC 4.0 BY-SA版权协议

收录于

23 篇文章

订阅专栏

本文介绍了Microsoft ADO.NET与Oracle ODP.NET之间的类型参照，并提供了关于32位和64位版本ODP.NET的问题解决方案及下载链接。

Microsoft (OracleType) - ODP.NET (OracleDbType) 类型参照

Oracle Data Type	ODP.NET (OracleDbType)	Microsoft (OracleType)
BFILE	BFile	BFile
BLOB	Blob	Blob
byte	Byte	Byte
CHAR	Char	Char
CLOB	Clob	Clob
DATE	Date	DateTime
8-byte FLOAT	Double	Double¹
2-byte INTEGER	Int16	Int16
4-byte INTEGER	Int32	Int32
8-byte INTEGER	Int64	N/A
INTERVAL DAY TO SECOND	IntervalDS	IntervalDayToSecond
INTERVAL YEAR TO MONTH	IntervalYM	IntervalYearToMonth
LONG	Long	LongVarChar
LONG RAW	LongRaw	LongRaw
NCHAR	NChar	NChar
NCLOB	NClob	NClob
NUMBER	Decimal	Number
NVARCHAR2	NVarchar2	NVarChar
RAW	Raw	Raw
REF CURSOR	RefCursor	Cursor
ROWID	N/A	RowId
4-byte FLOAT	Single	Float¹
TIMESTAMP	TimeStamp	Timestamp
TIMESTAMP WITH LOCAL TIME ZONE	TimeStampLTZ	TimestampLocal
TIMESTAMP WITH TIME ZONE	TimeStampTZ	TimestampWithTZ
VARCHAR2	Varchar2	VarChar
		SByte¹
		UInt16¹
		UInt32¹