mysql 邮箱长度,数据库中电子邮件地址的最佳长度是多少？

最新推荐文章于 2021-12-25 16:33:00 发布

添翼leo老师

最新推荐文章于 2021-12-25 16:33:00 发布

阅读量1.1k

点赞数

文章标签： mysql 邮箱长度

在数据库设计中，关于电子邮件地址字段的长度设置，作者发现在John Saunders的代码中使用了VARYING(256)，而自己的项目中只用了VARYING(20)。虽然普通邮件地址通常不会超过20字符，但根据RFC3696，邮件地址的最大长度为254字符，其中本地部分不超过64字符，域名部分不超过255字符。因此，最佳的数据库中电子邮件地址字段长度应考虑支持到254字符。

摘要由CSDN通过智能技术生成

I am doing my first database project.

I have had the following query in the column of EMAIL_ADDRESS:

...

EMAIL_ADDRESS CHARACTER VARYING(20) NOT NULL,

...

However, John Saunders uses VARYING(256).

This suggests me that I have not necessarily understood the VARYING correctly. I understand it such that the length of an email-address is 20 characters in my case, while 256 for Jodn.

Context in John's code

CREATE TABLE so."User"

(

USER_ID SERIAL NOT NULL,

USER_NAME CHARACTER VARYING(50) NOT NULL,

EMAIL_ADDRESS CHARACTER VARYING(256) NOT NULL, /// Here

HASHED_PASSWORD so.HashedPassword NOT NULL,

OPEN_ID CHARACTER VARYING(512),

A_MODERATOR BOOLEAN,

LOGGED_IN BOOLEAN,

HAS_BEEN_SENT_A_MODERATOR_MESSAGE BOOLEAN,

CONSTRAINT User_PK PRIMARY KEY(US