ADO data types - need definitions/explanations

bhill5

what are these? when do you use them? why one over another? thanks

Data types
string
long
float
bool
date
datetime
datetimetz

JonFerneau

Data Type	Description
string	Used for storing text, such as names, addresses, or any other sequence of characters.
long	A numeric data type for storing large whole numbers.
float	Used for storing numbers that have a fractional part, also known as floating-point numbers.
bool	A data type that can only hold two values: TRUE or FALSE.
date	Used to store a date (year, month, and day).
datetime	Used to store both a date and a time of day (year, month, day, hour, minute, second).
datetimetz	Similar to datetime, but it also includes information about the timezone.