[TYPO3-dev] Default definitions of database fields

[Franz Koch]

Hi Jochen,

> I will sum up now my and the other participants findings in this thread.
...

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.

-- 
kind regards,
Franz Koch