Visual Basic, VB .NET, ASP, Active X, Access, SQL Server

Tabela de Conversão de Tipos de Dados


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


E-mail: codelines@codelines.com
Fone: (011) 6198-5137
Revisada: abril 05, 2004.