问题描述
我有一个简单的Web表单,该表单将允许未经身份验证的用户输入其信息,包括姓名.我给name字段指定了50个字符的限制,以使其与数据库表中的字段varchar(50)一致,但是后来我开始怀疑.
使用类似文本"列类型的名称还是更合适,还是应该将名称的长度限制为合理的范围?
如果您的回复很重要,我正在使用SQL Server 2005.
编辑:我没有看到这更广泛的信息有关类似问题的问题.
英国政府数据标准目录建议为每个给定名称和姓氏使用35个字符,或为单个字段保留全名使用70个字符. >
I have a simple webform that will allow unauthenticated users to input their information, including name. I gave the name field a limit of 50 characters to coincide with my database table where the field is varchar(50), but then I started to wonder.
Is it more appropriate to use something like the Text column type or should I limit the length of the name to something reasonable?
I'm using SQL Server 2005, in case that matters in your response.
EDIT: I did not see this broader question regarding similar issues.
UK Government Data Standards Catalogue suggests 35 characters for each of Given Name and Family Name, or 70 characters for a single field to hold the Full Name.
这篇关于人&“姓名&"的合理长度限制是多少?领域?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!