| [ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] |
MySQL supports a number of column types in several categories: numeric types, date and time types, and string (character) types. This chapter first gives an overview of these column types, and then provides a more detailed description of the properties of the types in each category, and a summary of the column type storage requirements. The overview is intentionally brief. The more detailed descriptions should be consulted for additional information about particular column types, such as the allowable formats in which you can specify values.
MySQL 4.1 and up supports extensions for handing spatial data. Information about spatial types is provided in Spatial Extensions in MySQL.
Several of the column type descriptions use these conventions:
MIndicates the maximum display size. The maximum legal display size is 255.
DApplies to floating-point and fixed-point types and indicates the number of
digits following the decimal point. The maximum possible value is 30, but
should be no greater than M-2.
Square brackets (`[' and `]') indicate parts of type specifiers that are optional.
This document was generated on July, 26 2004 using texi2html 1.70.