티스토리 뷰

WEB TIP/ASP

ADO 데이터형 상수

제프 2006. 11. 13. 15:46
출처: 액션필터

ADO 데이터형 상수

ConstantValueDescription
AdArray(Does not apply to ADOX.)0x2000A flag value, always combined with another data type constant, that indicates an array of that other data type.
adBigInt20Indicates an eight-byte signed integer (DBTYPE_I8).
adBinary128Indicates a binary value (DBTYPE_BYTES).
adBoolean11Indicates a boolean value (DBTYPE_BOOL).
adBSTR8Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR).
adChapter136Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER).
adChar129Indicates a string value (DBTYPE_STR).
adCurrency6Indicates a currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000.
adDate7Indicates a date value (DBTYPE_DATE). A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day.
adDBDate133Indicates a date value (yyyymmdd) (DBTYPE_DBDATE).
adDBTime134Indicates a time value (hhmmss) (DBTYPE_DBTIME).
adDBTimeStamp135Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).
adDecimal14Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
adDouble5Indicates a double-precision floating-point value (DBTYPE_R8).
adEmpty0Specifies no value (DBTYPE_EMPTY).
adError10Indicates a 32-bit error code (DBTYPE_ERROR).
adFileTime64Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME).
adGUID72Indicates a globally unique identifier (GUID) (DBTYPE_GUID).
adIDispatch9Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH).

Note   This data type is currently not supported by ADO. Usage may cause unpredictable results.

adInteger3Indicates a four-byte signed integer (DBTYPE_I4).
adIUnknown13Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN).

Note   This data type is currently not supported by ADO. Usage may cause unpredictable results.

adLongVarBinary205Indicates a long binary value.
adLongVarChar201Indicates a long string value.
adLongVarWChar203Indicates a long null-terminated Unicode string value.
adNumeric131Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
adPropVariant138Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT).
adSingle4Indicates a single-precision floating-point value (DBTYPE_R4).
adSmallInt2Indicates a two-byte signed integer (DBTYPE_I2).
adTinyInt16Indicates a one-byte signed integer (DBTYPE_I1).
adUnsignedBigInt21Indicates an eight-byte unsigned integer (DBTYPE_UI8).
adUnsignedInt19Indicates a four-byte unsigned integer (DBTYPE_UI4).
adUnsignedSmallInt18Indicates a two-byte unsigned integer (DBTYPE_UI2).
adUnsignedTinyInt17Indicates a one-byte unsigned integer (DBTYPE_UI1).
adUserDefined132Indicates a user-defined variable (DBTYPE_UDT).
adVarBinary204Indicates a binary value.
adVarChar200Indicates a string value.
adVariant12Indicates an Automation Variant (DBTYPE_VARIANT).

Note   This data type is currently not supported by ADO. Usage may cause unpredictable results.

adVarNumeric139Indicates a numeric value.
adVarWChar202Indicates a null-terminated Unicode character string.
adWChar130Indicates a null-terminated Unicode character string (DBTYPE_WSTR).

'WEB TIP > ASP' 카테고리의 다른 글

ASP에서 엑셀파일 변환시 수식 입력  (0) 2007.01.12
페이지 오픈과동시에 다운로드  (0) 2006.11.29
ADO 데이터형 상수  (0) 2006.11.13
일문을 oracle에 저장시 특정문자 에러 날때  (0) 2006.08.18
MIME TYPE  (0) 2006.07.19
utf-8 다국어 ASP 페이지  (1) 2006.07.11
공유하기 링크
TAG
,
댓글
댓글쓰기 폼