ADO 데이터 타입 비교 테이블

ADO DataType Enum ADO DataType Enum Value .NET Framework Visual Basic 6.0 Access SQL Server Oracle adBigInt 20 Int64 SqlInt64 BigInt Variant BigInt adBinary 128 Byte[] SqlBinary Binary Variant Binary TimeStamp Raw adBoolean 11 Boolean SqlBoolean Boolean Boolean YesNo Bit adBSTR 8 String BSTR adChapter 136 (DataReader) adChar 129 String SqlString Char String Char Char adCurrency 6 Decimal SqlMoney Currency Currency Currency Money SmallMoney adDate 7 DateTime Date Date DateTime adDBDate 133 DateTime DBDate adDBFileTime 137 DBFileTime adDBTime 134 DateTime DBTime adDBTimeStamp 135 DateTime SqlDateTime DBTimeStamp Date DateTime Datetime SmallDateTime Date adDecimal 14 Decimal Decimal Variant Decimal adDouble 5 Double SqlDouble Double Double Double Float Float adEmpty 0 Empty adError 10 External-Exception Error adFileTime 64 DateTime Filetime adGUID 72 Guid SqlGuid Guid Variant ReplicationID UniqueIdentifier adIDispatch 9 Object IDispatch adInteger 3 Int32 SqlInt32 Integer Long AutoNumber Integer Long Identity Int Int adIUnknown 13 Object IUnknown adLongVarBinary 205 Byte[] SqlBinary LongVarBinary Variant OLEObject Image Long Raw Blob adLongVarChar 201 String SqlString LongVarChar String Memo Hyperlink Text Long Clob adLongVarWChar 203 String SqlString LongVarWChar String Memo Hyperlink NText NClob adNumeric 131 Decimal SqlDecimal Numeric Variant Decimal Decimal Numeric Decimal Integer Number SmallInt adPropVariant 138 Object PropVariant adSingle 4 Single SqlSingle SIngle Single Single Real adSmallInt 2 Int16, SqlInt16 SmallInt Integer Integer SmallInt adTinyInt 16 Byte TinyInt adUnsignedBigInt 21 UInt64 UnsignedBigInt adUnsignedInt 19 UInt32 UnsignedInt adUnsignedSmallInt 18 UInt16 UnsignedSmallInt adUnsignedTinyInt 17 Byte SqlByte UnsignedTinyInt Byte Byte TinyInt adUserDefined 132 adVarBinary 204 Byte[] SqlBinary VarBinary Variant ReplicationID VarBinary adVarChar 200 String SqlString VarChar String Text VarChar VarChar adVariant 12 Object Variant Variant Sql_Variant VarChar2 adVarNumeric 139 VarNumeric adVarWChar 202 String SqlString VarWChar String Text NVarChar NVarChar2 adWChar 130 String SqlString WChar String NChar