⚠️ This page has been archived

✅ New page with updated info: ssw.com.au

SQL Data Type Mapping

Jet SQL Server
Text char, nchar, varchar, nvarchar
Memo text, ntext
Byte tinyint
Integer smallint
Long Integer integer
Single real
Double float
Replication ID uniqueidentifier
Decimal decimal
Date/Time smalldatetime, datetime, timestamp
Currency smallmoney, money
AutoNumber int + identity property
Yes/No bit
OLE Object image
Hyperlink <no equivalent>
<no equivalent> binary, varbinary

SQL Server 2000 introduced new data types not supported in SQL Server 7: sql_variant and bigint (integer data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807). Storage size is 8 bytes.).

Sergei Tchernykh and Adam Cogan
November 2000