来自: http://support.microsoft.com/default.aspx?scid=kb%3Bzh-cn%3B214854
ODBC 与 Jet 数据类型映射
ODBC SQL Type Precision Scale Jet 3.5 Type Jet 40 Type ----------------------------------------------------------- SQL_BIT N/A N/A Boolean Boolean SQL_TINYINT N/A N/A Byte* Byte* SQL_TINYINT N/A N/A Integer* Integer* SQL_SMALLINT N/A N/A Integer Integer SQL_INTEGER N/A N/A Long Long SQL_REAL N/A N/A Single Single SQL_FLOAT N/A N/A Double Double SQL_DOUBLE N/A N/A Double Double SQL_DECIMAL 0 To 4 0 Integer Decimal SQL_DECIMAL 5 To 9 0 Long Decimal SQL_DECIMAL 10 to 15 0 Double Decimal SQL_DECIMAL <=15 >0 Double Decimal SQL_DECIMAL 16 To 28 N/A Text Decimal SQL_DECIMAL > 28 N/A Text Text SQL_NUMERIC 0 To 4 0 Integer Decimal SQL_NUMERIC 5 To 9 0 Long Decimal SQL_NUMERIC 10 to 15 0 Double Decimal SQL_NUMERIC <=15 >0 Double Decimal SQL_NUMERIC 16 To 28 N/A Text Decimal SQL_NUMERIC > 28 N/A Text Text SQL_CHAR <= 255 N/A Text Text SQL_CHAR > 255 N/A Memo Memo SQL_VARCHAR <= 255 N/A Text Text SQL_VARCHAR > 255 N/A Memo Memo SQL_LONGVARCHAR N/A N/A Memo Memo SQL_WCHAR <= 255 N/A Unsupported Text SQL_WCHAR > 255 N/A Unsupported Memo SQL_WVARCHAR <= 255 N/A Unsupported Text SQL_WVARCHAR > 255 N/A Unsupported Memo SQL_WLONGVARCHAR N/A N/A Unsupported Memo SQL_DATE N/A N/A DateTime DateTime SQL_TIME N/A N/A DateTime DateTime SQL_TIMESTAMP N/A N/A DateTime DateTime SQL_BINARY <=255 N/A Binary Binary SQL_BINARY 256 To 510 N/A LongBinary Binary SQL_BINARY > 510 N/A LongBinary LongBinary SQL_VARBINARY <=255 N/A Binary Binary SQL_VARBINARY 256 To 510 N/A LongBinary Binary SQL_VARBINARY > 510 N/A LongBinary LongBinary SQL_LONGVARBINARY N/A N/A LongBinary LongBinary SQL_GUID N/A N/A Text Guid * An unsigned SQL_TINYINT maps to a Jet Byte, a signed SQL_TINYINT maps to an Jet Integer.
特殊 ODBC 到 Jet - 数据类型映射为 SQLServer
MicrosoftJet 是与 Microsoft SQL Server ODBC 驱动程序, 如果发生下列其他数据类型映射：ODBC SQL Type Precision Scale Jet 3.5 Type Jet 40 Type ----------------------------------------------------------- SQL_DECIMAL 10 4 Currency Currency SQL_DECIMAL 19 4 Currency Currency SQL_NUMERIC 10 4 Currency Currency SQL_NUMERIC 19 4 Currency Currency
