List of standard lengths for database fields

by

I just queried my database with millions of customers in the USA.

  • The maximum first name length was 46. I go with 50. (Of course, only 500 of those were over 25, and they were all cases where data imports resulted in extra junk winding up in that field.)

  • Last name was similar to first name.

  • Email addresses maxed out at 62
    characters. Most of the longer ones
    were actually lists of email
    addresses separated by semicolons.

  • Street address maxes out at 95
    characters. The long ones were all
    valid.

  • Max city length was 35.

This should be a decent statistical spread for people in the US. If you have localization to consider, the numbers could vary significantly.

More Related Contents:

  1. Display dynamic image from database or remote source with p:graphicImage and StreamedContent
  2. Version of SQLite used in Android?
  3. What are the performance characteristics of sqlite with very large database files? [closed]
  4. Primary keys with Apache Spark
  5. What are database normal forms and can you give examples? [closed]
  6. Exposing database IDs – security risk?
  7. How can I put a database under git (version control)?
  8. How to use mongoimport to import csv
  9. NoSql vs Relational database
  10. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  11. Best way to test a MS Access application?
  12. Partial Dependency (Databases)
  13. Can I rollback a transaction I’ve already committed? (data loss)
  14. internationalization in JSF with ResourceBundle entries which are loaded from database
  15. How to backup sqlite database?
  16. Microservices with shared database? using multiple ORM’s? [closed]
  17. What’s the best strategy for unit-testing database-driven applications?
  18. Saving images: files or blobs?
  19. Still Confused About Identifying vs. Non-Identifying Relationships
  20. Normal forms – 2nd vs 3rd – is the difference just composite keys? non trivial dependency?
  21. Is there any NoSQL data store that is ACID compliant?
  22. How to think in data stores instead of databases?
  23. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  24. Is it a good idea to use an integer column for storing US ZIP codes in a database?
  25. Connect to a heroku database with pgadmin
  26. Starting and populating a Postgres container in Docker
  27. Need help in developing DB logic
  28. How to find SQLITE database file version
  29. Oracle: How do I convert hex to decimal in Oracle SQL?
  30. Pros/cons of document-based databases vs. relational databases

Leave a Comment