From: http://support.microsoft.com/default.aspx? SCID = kb % 3bzh-cn % 3b214854
ODBC and jet data type ing
Odbc SQL Type Precision Scale jet 3.5 type jet 40 type ----------------------------------------------------------- SQL _bit N/A boolean booleansql_tinyint N/A byte * SQL _tinyint N/A integer * integer * SQL _smallint N/A integer integersql_integer N/A Long longsql_real N/A single singlesql_float N/A double doublesql_double N/A N/ A double doublesql_decimal 0 to 4 0 integer decimalsql_decimal 5 to 9 0 long decimalsql_decimal 10 to 15 0 double digit <= 15> 0 double decimalsql_decimal 16 to 28 N/A text decimalsql_decimal> 28 N/ A text textsql_numeric 0 to 4 0 integer decimalsql_numeric 5 to 9 0 long decimalsql_numeric 10 to 15 0 double limit <= 15> 0 double decimalsql_numeric 16 to 28 N/A text decimalsql_numeric> 28 N/ A text textsql_char <= 255 N/A text textsql_char> 255 n/a memo memosql_varchar <= 255 N/A text textsql_varchar> 255 n/a memo memosql_longvarchar N/A memo memosql_wchar <= 255 N/A unsupported textsql_wchar> 255 N/A unsupported limit <= 255 N/A unsupported limit> 255 N/A unsupported limit N/A unsupported memosql_date n /a n/A datetime datetimesql_time N/A datetime datetimesql_timestamp N/A datetime datetimesql_binary <= 255 N/A binary binarysql_binary 256 to 510 N/A longbinary binarysql_binary> 510 N/A longbinary limit <= 255 N/A binary binarysql_varbinary 256 to 510 N/A longbinary binarysql_varbinary> 510 N/A longbinary limit N/A longbinary longbinarysql_guid N/ n/A text guid * an unsigned SQL _tinyint maps to a jet byte, A signed SQL _tinyintmaps to an jet integer.
Special ODBC to jet-Data Type ing to sqlserver
Microsoftjet is an ODBC driver with Microsoft SQL Server.ProgramIf the following data type ing occurs:
Odbc SQL Type Precision Scale jet 3.5 type jet 40 type export SQL _decimal 10 4 currency currencysql_decimal 19 4 currency currencysql_numeric 10 4 currency currencysql_numeric 19 4 currency