Acceptable field type and size for email address?

mysql size email-address fieldtype
Guapo picture Guapo · Nov 23, 2011 · Viewed 64.9k times · Source

Possible Duplicate:
Common mySQL fields and their appropriate data types
What are the recommended database column sizes for names?

I am looking for what would be the most correct field type and size to store email address into a mysql table.

I was initially considering varchar 255 but I think 255 might be too much or even too little what is the average size where I would be able to catch all kinda of valid email address ?

Answer

socha23 picture socha23 · Nov 23, 2011

According to RFC 5321, forward and reverse path can be up to 256 chars long, so the email address can be up to 254 characters long. You're safe with using 255 chars.

Related questions

How to Get True Size of MySQL Database?

I would like to know how much space does my MySQL database use, in order to select a web host. I found the command SHOW TABLE STATUS LIKE 'table_name' so when I do the query, I get something like …

Read More
MySQL VARCHAR size limit

If I have a column in table with field of type VARCHAR(15) and if I try to insert data of length 16, MySQL gives an error stating Data too long for column 'testname' at row 1 Does anyone know why VARCHAR fields …

Read More
MySQL error: The maximum column size is 767 bytes

When I run a program which does something with MySQL, I got this error message: 2015-06-10 15:41:12,250 ERROR app.wsutils 419 INCRON: Error: ('HY000', '[HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.7.7-rc-log]Index column size too large. The maximum column …

Read More