(mysql.info.gz) Column types
11 Column Types
* Column type overview Column Type Overview
* Numeric types Numeric Types
* Date and time types Date and Time Types
* String types String Types
* Storage requirements Column Type Storage Requirements
* Choosing types Choosing the Right Type for a Column
* Other-vendor column types Using Column Types from Other Database Engines
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 versions 4.1 and up support extensions for handing spatial data.
Information about spatial types is provided in Spatial extensions
Several of the column type descriptions use these conventions:
Indicates the maximum display width. The maximum legal display
width is 255.
Applies 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.
automatically generated byinfo2html