[TYPO3-dev] Default definitions of database fields

[Susanne Moog]

Hi,

Am 12.02.2010 00:24, schrieb Jochen Rau:
> Hi.

> ---snip
> "This optional display width may be used by applications to display
> integer values having a width less than the width specified for the
> column by left-padding them with spaces. (That is, this width is present
> in the metadata returned with result sets. Whether it is used or not is
> up to the application.)
> 
> The display width does not constrain the range of values that can be
> stored in the column, nor the number of digits that are displayed for
> values having a width exceeding that specified for the column."
> ---snip
> 
> I think we should allow the developers to drop this information
> (currently the EM complaints about this).

found what I meant in the manual:

"Note that if you store larger values than the display width in an
integer column, you may experience problems when MySQL generates
temporary tables for some complicated joins, because in these cases
MySQL assumes that the data fits into the original column width."

So yes, it's not used for storing, but used for the joins...

Best regards,

Susanne