|
Tipo de dados DAO |
Tipo de dados ADO |
| dbBoolean | adBoolean |
| dbByte | adUnsignedTinyInt |
| dbCurrency | adCurrency |
| dbDate | adDate |
| dbDecimal | adNumeric |
| dbDouble | adDouble |
| dbGUID | adGUID |
| dbInteger | adSmallInt |
| dbLong | adInteger |
| dbLongBinary (OLE Object) | adLongVarBinary |
| dbMemo | adLongVarWChar |
| dbSingle | adSingle |
| dbText | adVarWChar |
|
Tipo de dados SQL Server |
Tipo de dados ADO |
|
Bit |
adBoolean |
|
TinyInt |
adTinyInt |
|
SmallInt |
adSmallInt |
|
Int |
adInteger |
|
Real |
adSingle |
|
Float |
adDouble |
|
Money |
adCurrency |
|
Smallmoney |
adCurrency |
|
Decimal |
adDecimal |
|
Numeric |
adNumeric |
|
Datetime |
adDate |
|
Smalldatetime |
adDBDate |
|
Int |
adInteger |
|
Varchar(n) |
adVarchar |
|
Nvarchar(n) |
adVarchar |
|
Text |
adLongVarWChar |
|
Image |
adLongVarBinary |
|
Uniqueidentifier |
adGUID |