ADO 与 SQL Sverver 数据类型的映射关系

adEmpty = "Empty"
        adTinyInt = "TinyInt"
        adSmallInt = "SmallInt"
        adInteger = "Integer"
        adBigInt = "BigInt"
        adUnsignedTinyInt = "UnsignedTinyInt"
        adUnsignedSmallInt = "UnsignedSmallInt"
        adUnsignedInt = "UnsignedInt"
        adUnsignedBigInt = "UnsignedBigInt"
        adSingle = "Single"
        adDouble = "Double"
        adCurrency = "Currency"
        adDecimal = "Decimal"
        adNumeric = "Numeric"
        adBoolean = "Boolean"
        adError = "Error"
        adUserDefined = "UserDefined"
        adVariant = "Variant"
        adIDispatch = "IDispatch"
        adIUnknown = "IUnknow"
        adGUID = "GUID"
        adDate = "Date"
        adDBDate = "DBDate"
        adDBTime = "DBTime"
        adDBTimeStamp = "DBTimeStamp"
        adBSTR = "BSTR"
        adChar = "Char"
        adVarChar = "VarChar"
        adLongVarChar = "LongVarChar"
        adWChar = "WChar"
        adVarWChar = "VarWChar"
        adLongVarWChar = "LongVarWChar"
        adBinary = "Binary"
        adVarBinary = "VarBinary"
        adLongVarBinary = "LongVarBinary"
        adChapter = "Chapter"
        adFileTime = "FileTime"
        adPropVariant = "PropVariant"
        adVarNumeric = "VarNumeric"
        adArray = "Array"
posted on 2005-03-16 12:24  轻松逍遥子  阅读(420)  评论(0编辑  收藏  举报