vb怎么定义varchar(8)类型的数据,来与数据库里的数据类型匹配
使用adChar
英文的参数类型说明
Constant Description
adArray Joined in a logical OR together with another type to indicate that the data is a safe-array of that type (DBTYPE_ARRAY)。
adBigInt An 8-byte signed integer (DBTYPE_I8)。
adBinary A binary value (DBTYPE_BYTES)。
adBoolean A Boolean value (DBTYPE_BOOL)。...全部
使用adChar
英文的参数类型说明
Constant Description
adArray Joined in a logical OR together with another type to indicate that the data is a safe-array of that type (DBTYPE_ARRAY)。
adBigInt An 8-byte signed integer (DBTYPE_I8)。
adBinary A binary value (DBTYPE_BYTES)。
adBoolean A Boolean value (DBTYPE_BOOL)。
adByRef Joined in a logical OR together with another type to indicate that the data is a pointer to data of the other type (DBTYPE_BYREF)。
adBSTR A null-terminated character string (Unicode) (DBTYPE_BSTR)。
adChar A String value (DBTYPE_STR)。
adCurrency 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 8-byte signed integer scaled by 10,000。
adDate 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。
adDBDate A date value (yyyymmdd) (DBTYPE_DBDATE)。
adDBTime A time value (hhmmss) (DBTYPE_DBTIME)。
adDBTimeStamp A date-time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP)。
adDecimal An exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL)。
adDouble A double-precision floating point value (DBTYPE_R8)。
adEmpty No value was specified (DBTYPE_EMPTY)。
adError A 32-bit error code (DBTYPE_ERROR)。
adGUID A globally unique identifier (GUID) (DBTYPE_GUID)。
adIDispatch A pointer to an IDispatch interface on an OLE object (DBTYPE_IDISPATCH)。
adInteger A 4-byte signed integer (DBTYPE_I4)。
adIUnknown A pointer to an IUnknown interface on an OLE object (DBTYPE_IUNKNOWN)。
adLongVarBinary A long binary value (Parameter object only)。
adLongVarChar A long String value (Parameter object only)。
adLongVarWChar A long null-terminated string value (Parameter object only)。
adNumeric An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC)。
adSingle A single-precision floating point value (DBTYPE_R4)。
adSmallInt A 2-byte signed integer (DBTYPE_I2)。
adTinyInt A 1-byte signed integer (DBTYPE_I1)。
adUnsignedBigInt An 8-byte unsigned integer (DBTYPE_UI8)。
adUnsignedInt A 4-byte unsigned integer (DBTYPE_UI4)。
adUnsignedSmallInt A 2-byte unsigned integer (DBTYPE_UI2)。
adUnsignedTinyInt A 1-byte unsigned integer (DBTYPE_UI1)。
adUserDefined A user-defined variable (DBTYPE_UDT)。
adVarBinary A binary value (Parameter object only)。
adVarChar A String value (Parameter object only)。
adVariant An Automation Variant (DBTYPE_VARIANT)。
adVector Joined in a logical OR together with another type to indicate that the data is a DBVECTOR structure, as defined by OLE DB, that contains a count of elements and a pointer to data of the other type (DBTYPE_VECTOR)。
adVarWChar A null-terminated Unicode character string (Parameter object only)。
adWChar A null-terminated Unicode character string (DBTYPE_WSTR)。
。收起