[TYPO3-dev] Default definitions of database fields

[Jochen Rau]

Hi Franz.

> 5. Use the same field length definition among fields relating or
> comparable to each other. So if you for example have a category field in
> your table, referring to the uid of a category table, your category
> field should have the same field/byte length as the uid field of the
> category table. This is needed that MYSQL can compare the field values
> more easily when dealing with JOIN and intermediate SQL queries. It's
> especially recommended for fields storing strings, but should also apply
> for integers I think.
> At least I read this somewhere these days. Please correct me if I'm wrong.

Thanks for the addition. But I did not find any hint in the literature 
according to *integers*. IMO it has no effect to have the same display 
length as long as the display length is not too short for the content. 
So, joining int(3) and int(11) should have no relevancy in sense of 
performance.

Maybe you can point me to some docs?

Jochen