You are here: start » misc » misc:database_field_lengths
The following is a list of the longest possible values for Cities, States/Provinces, Countries, Phone Numbers, etc. If you know something to be incorrect, please update the wiki.
These values are useful when determining the required length field for your database.
FirstName: 35 (http://stackoverflow.com/questions/128099/what-is-the-longest-human-name-you-can-expect)
LastName: 21 (http://thelongestlistofthelongeststuffatthelongestdomainnameatlonglast.com/long42.html)
City: 58 (http://www.thailandlife.com/ericshackle/placename.html)
State: 30 - guess
Zip: 10 -guess
Phone: 17 -guess
country: 74 (http://thelongestlistofthelongeststuffatthelongestdomainnameatlonglast.com/long161.html)
What is the Maximum And Minimum Value for Latitude and Longitude?
Maximum value of Latitude is 90 degrees (at the poles)
Minimum value of Latitude is 0 degrees (at the Equator)
Maximum value of Longitude is 180 degrees ( eastward from Greenwitch)
Minimum value of Longitude is -180 degrees ( westward from Greenwitch)