What is the optimal length for an email address in a database?

by

The maximum length of an email address is 254 characters.

Every email address is composed of two parts. The local part that comes before the ‘@’ sign, and the domain part that follows it. In “[email protected]”, the local part is “user”, and the domain part is “example.com”.

The local part must not exceed 64 characters and the domain part cannot be longer than 255 characters.

The combined length of the local + @ + domain parts of an email address must not exceed 254 characters. As described in RFC3696 Errata ID 1690.

I got the original part of this information from here

More Related Contents:

  1. In what way does denormalization improve database performance?
  2. Is storing a delimited list in a database column really that bad?
  3. Should each and every table have a primary key?
  4. Database development mistakes made by application developers [closed]
  5. Database, Table and Column Naming Conventions? [closed]
  6. Surrogate vs. natural/business keys [closed]
  7. How are super- and subtype relationships in ER diagrams represented as tables?
  8. What is the best design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  9. When and why are database joins expensive?
  10. Normalization: What does “repeating groups” mean?
  11. First name, middle name, last name. Why not Full Name?
  12. Relational table naming convention [closed]
  13. What are the design criteria for primary keys?
  14. When I should use one to one relationship?
  15. DOs and DONTs for Indexes [closed]
  16. Supertype-subtype database design
  17. Database optimization orders
  18. What’s wrong with nullable columns in composite primary keys?
  19. Best representation of an ordered list in a database?
  20. have address columns in each table or an address table that is referenced by the other tables?
  21. Minimum no of tables that exists after decomposing relation R into 1NF?
  22. Limit an sqlite Table’s Maximum Number of Rows
  23. NULL permitted in Primary Key – why and in which DBMS?
  24. What are some best practices and “rules of thumb” for creating database indexes?
  25. When we need to use 1-to-1 relationship in database design?
  26. Need help in developing DB logic
  27. What’s the better database design: more tables or more columns?
  28. Should OLAP databases be denormalized for read performance? [closed]
  29. Best beginner resources for understanding the EAV database model? [closed]
  30. Database – Data Versioning [closed]

Leave a Comment