Subject Re: Default Field Lengths
Author russellbelding
--- In, "jwcane2003" <jwcane@...> wrote:
> Is there an authoritative listing of standard or recommended lengths of fields like first/last names, street, city, etc.
I've not heard of an "authoritative" recommendation for these. One way to proceed is to examine sample data and cater for the longest lengths you see. Several factors come into play in my apps. In one app I use first and last name fields as varChar(24). In another app I use a text blob for each of the fields you mention above. If the name and location values wers always used together you coud use a text blob for the collection ... Maybe "tailor to your needs" is a fair suggestion?