database design - Field size recommendation? -


is there place can find recommendation length of fields should set in database?

i started fixing bugs in project of fields set 50...

first name, last name, email...

i think in case, first name , last name less 50...

anyway, doesn't hurt ask =)

the correct answer "as large possible".

most database fields variable size, doesn't matter random number pick.

therefore, pick largest random number can away with.

i go 255 unless there's compelling reason not to.

one compelling reasons shorter overall row size huge.

the other compelling reason actual defined standard maximum length.


Comments