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