Varchar(n) | n chars | 1 to 32765 bytes | Variable length char or text string. NB, multi-byte character sets reduce number of possible characters proportionately. |

SmallInt | 16 bits | -2^15 to 2^15-1 | Signed short (word) |

Integer | 32 bits | -2^31 to 2^31-1 | Signed long (longword) |

BigInt | 64 bits | -2^63 to 2^63-1 | Signed long long (quadword) |

Float | 32 bits | 3.4 x 10^-38 to 3.4 x 10^38 | Accurate to 7 digits |

Double Precision | 64 bits | 1.7 x 10^-308 to 1.7 x 10^308 | Accurate to 15 digits |

Timestamp | 64 bits (2 X 32 bits) | 1 Jan 100 CE to 28 Feb 32768 CE | Includes time and date as two 32-bit structures |

Date | 32 bits | 1 Jan 100 CE to 28 Feb 32768 CE | Date only. Time part is not stored. |

Time | 32 bits | 0:00 to 23:59.9999 | |

BLOB | <32GB | -- | Stores data of variable indeterminate size |

Numeric (*precision, scale*) | Variable (16, 32, or 64 bits) | specifies exactly precision digits of precision | Example: Numeric(10,3) holds numbers accurately in the following format: ppppppp.sss |

Decimal (*precision, scale*) | Variable (16, 32, or 64 bits) | specifies at least precision digits of precision | Example: Decimal(10,3) holds numbers accurately in the following format: ppppppp.sss |