| Size | Comment |
BINARY | 1 byte per «character» | Any type of data may be stored in a field of this type. |
BIT | 1 | True (-1)/ False (0) |
TINYINT | 1 | An integer value between 0 and 255. |
MONEY | 8 | A scaled integer |
DATETIME | 8 bytes | A date or time (stored as a double ?), range is between the years 100 and 9999. |
UNIQUEIDENTIFIER | 128 bits | A unique identification number used with remote procedure calls. |
REAL | 4 | Single-precision floating-point value |
FLOAT | 8 | Double-precision floating-point value |
SMALLINT | 2 | |
INTEGER | 4 | |
DECIMAL | 17 | An exact numeric data type with definable precision (1-28, default 18) ans scale (0). |
TEXT | 2 bytes per character | |
IMAGE | As required | Zero to a maximum of 2.14 GB. Used for OLE objects. |
CHAR | 2 per character | Maximal length 255 characters. Aka CHARACTER ? |