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