ADO ObjectsLesson 79Free preview

ADO DataTypes

This lesson is part of ASP · All levels

Summary

ADO provides data type constants such as adVarChar, adInteger, adDate, and adLongVarWChar that reflect the column type in the database. Selecting the right type is important when creating parameters so that the value is acceptable and not cut. Here is a list of the most common types of access when working with Access and SQL Server.

Key points

Short text types use adVarChar or adVarWChar, long text uses adLongVarWChar.
The integers use an adInteger, the decimals use an adDouble or an adNumeric.
AdCurrency is used for fixed-precision monetary value.
AdDate keeps the date and time.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.