For non-US databases, the phone field will need to be at least 15 (my UK mobile and domestic is 11, many UK domestics are longer, some UK businesses have additional ~4 extension numbers on the end as well!)

Non-US postcodes vary considerably in both length and format.

(You said you wanted international information as well).

>Standard length fields
>
>Most of my database design is aimed to Mexico and Latin America. However, this time I need to create a database where common used standard fields will be there for the American and International user.
>
>I’ll appreciate any advice about field lengths for the next list of fields.
>
>Thanks in advance
>
>Phone
>Addres
>City
>Social Security No.
>Zip
>First Name
>Last Name
>Second Name
>
>Oscar