ADO DataType 목록

플밍_ASP 2013.01.30 17:16



제목 :  ADO DataType 목록


ADO DataType 목록




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).



Posted by 잠수콩