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