Easy Tutorial
Ado Ref Error Ado Sort Ado Ref Record Ado Display Ado Command Index Ado Ref Stream Ado Tutorial Ado Connect Ado Intro Ado Query Ado Examples Ado Summary Ado Datatypes Ado Ref Recordset Ado Ref Field Ado Getstring Ado Add Ado Recordset Ado Ref Connection Ado Ref Parameter Ado Ref Property Ado Delete Ado Update
❮ Ado Summary Ado Ref Recordset ❯

ADO Data Types

The following table lists the data type mappings between Access, SQL Server, and Oracle:

DataType Enum Value Access SQLServer Oracle
adBigInt 20 BigInt (SQL Server 2000 +)
adBinary 128 Binary <br>TimeStamp Raw *
adBoolean 11 YesNo Bit
adChar 129 Char Char
adCurrency 6 Currency Money <br>SmallMoney
adDate 7 Date DateTime
adDBTimeStamp 135 DateTime (Access 97 (ODBC)) DateTime <br>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 <br>Integer <br>Long Identity (SQL Server 6.5) <br>Int <br> Int *
adLongVarBinary 205 OLEObject Image Long Raw * <br>Blob (Oracle 8.1.x)
adLongVarChar 201 Memo (Access 97) <br>Hyperlink (Access 97) Text Long * <br>Clob (Oracle 8.1.x)
adLongVarWChar 203 Memo (Access 2000 (OLEDB)) <br>Hyperlink (Access 2000 (OLEDB)) NText (SQL Server 7.0 +) NClob (Oracle 8.1.x)
adNumeric 131 Decimal (Access 2000 (OLEDB)) Decimal <br>Numeric Decimal <br>Integer <br>Number <br>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 +)
❮ Ado Summary Ado Ref Recordset ❯