ADO Data Types corresponds to database values

The table below shows the ADO data type mapping between access, SQL Server, and Oracle:

Datatype Enum	Value	Access	Sqlserver	Oracle
Adbigint	20		Bigint (SQL Server 2000 +)
Adbinary	128		Binary Timestamp	Raw *
Adboolean	11	Yesno	Bit
Adchar	129		Char	Char
Adcurrency	6	Currency	Money Smallmoney
Addate	7	Date	Datetime
Addbtimestamp	135	Datetime (Access 97 (ODBC ))	Datetime Smalldatetime	Date
Addecimal	14			Decimal *
Addouble	5	Double	Float	Float
Adguid	72	Replicationid (Access 97 (oledb), (Access 2000 (oledb ))	Uniqueidentifier (SQL Server 7.0 +)
Adidispatch	9
Adinteger	3	Autonumber Integer Long	Identity (SQL Server 6.5) Int	Int *
Adlongvarbinary	205	Oleobject	Image	Long raw * Blob (Oracle 8.1.x)
Adlongvarchar	201	Memo (Access 97) Hyperlink (Access 97)	Text	Long * Clob (Oracle 8.1.x)
Adlongvarwchar	203	Memo (Access 2000 (oledb )) Hyperlink (Access 2000 (oledb ))	Ntext (SQL Server 7.0 +)	Nclob (Oracle 8.1.x)
Adnumeric	131	Decimal (Access 2000 (oledb ))	Decimal Numeric	Decimal Integer Number Smallint
Adsingle	4	Single	Real
Adsmallint	2	Integer	Smallint
Adunsignedtinyint	17	Byte	Tinyint
Advarbinary	204	Replicationid (Access 97)	Varbinary
Advarchar	200	Text (Access 97)	Varchar	Varchar
Advariant	12		SQL _variant (SQL Server 2000 +)	Varchar2
Advarwchar	202	Text (Access 2000 (oledb ))	Nvarchar (SQL Server 7.0 +)	Nvarchar2
Adwchar	130		Nchar (SQL Server 7.0 +)

* In Oracle 8.0.x-decimal and INT are equal to number and number (10 ).