2011. 7. 31.

ADO 데이터 타입 비교 테이블

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

댓글 없음:

댓글 쓰기