Extrait de MSDN:
Data type [Storage size] Description
* BINARY [1 byte per character] Any type of data may be stored in a field of this type. No translation of the data (for example, to text) is made. How the data is input in a binary field dictates how it will appear as output.
* BIT [1 byte] Yes and No values and fields that contain only one of two values.
* BYTE [1 byte] An integer value between 0 and 255.
* COUNTER [4 bytes] A number automatically incremented by the Microsoft Jet database engine whenever a new record is added to a table. In the Microsoft Jet database engine, the data type for this value is Long.
CURRENCY 8 bytes A scaled integer between – 922,337,203,685,477.5808 and 922,337,203,685,477.5807.
* DATETIME (See DOUBLE) [8 bytes] A date or time value between the years 100 and 9999.
* GUID [128 bits] A unique identification number used with remote procedure calls.
* SINGLE [4 bytes] A single-precision floating-point value with a range of – 3.402823E38 to – 1.401298E-45 for negative values, 1.401298E-45 to 3.402823E38 for positive values, and 0.
* DOUBLE [8 bytes] A double-precision floating-point value with a range of – 1.79769313486232E308 to – 4.94065645841247E-324 for negative values, 4.94065645841247E-324 to 1.79769313486232E308 for positive values, and 0.
* SHORT [2 bytes] A short integer between – 32,768 and 32,767.
* LONG [4 bytes] A long integer between – 2,147,483,648 and 2,147,483,647.
* LONGTEXT [1 byte] per character Zero to a maximum of 1.2 gigabytes.
LONGBINARY As required Zero to a maximum of 1.2 gigabytes. Used for OLE objects.
* TEXT [1 byte per character] Zero to 255 characters.
Partager