blocks|key|366616|text|我们使用50。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|366617|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

blocks|key|364847|text|如果它在一个字段中是全名，我通常会在单独的字段中使用128+-+64/64作为第一个和最后一个-你永远不会知道。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|364848|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If it's full name in one field, I usually go with 128 - 64/64 for first and last in separate fields - you just never know.

blocks|key|3161616|text|我通常使用varchar+(255+)+(255是MySQL中varchar类型的最大长度)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3161617|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I usually go with varchar(255) (255 being the maximum length of a varchar type in MySQL).

blocks|key|366662|text|名字的平均长度约为6个字母。那就剩下43个作为姓氏了。:)看起来你可以缩短它，如果你喜欢。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|366663|主要的问题是你认为你会有多少行？我不认为varchar(50)会杀死你，直到你得到几百万行。|366664|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

The average first name is about 6 letters. That leaves 43 for a last name. :) Seems like you could probably shorten it if you like.

The main question is how many rows do you think you will have? I don't think varchar(50) is going to kill you until you get several million rows.

blocks|key|369680|text|UK+Government+Data+Standards+Catalogue建议每个给定的姓名和家族名称使用35个字符，或者单个字段使用70个字符来保存全名。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|369681|entityMap|0|LINK|mutability|MUTABLE|url|http://webarchive.nationalarchives.gov.uk/20100407120701/http://cabinetoffice.gov.uk/govtalk/schemasstandards/e-gif/datastandards.aspx^0|0|12|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://webarchive.nationalarchives.gov.uk/20100407120701/http://cabinetoffice.gov.uk/govtalk/schemasstandards/e-gif/datastandards.aspx" rel="noreferrer">UK Government Data Standards Catalogue</a> suggests 35 characters for each of Given Name and Family Name, or 70 characters for a single field to hold the Full Name.

blocks|key|366687|text|@Ian+Nelson:我想知道其他人是否看到了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|366688|假设你有拆分的字段。总共70个字符，名35个，姓35个。但是，如果你只有一个字段，你就会忽略名字和姓氏之间的空格，将你的名字缩短了1个字符。当然，它“只”是一个字符，但这可能会造成一些人输入他们的全名和另一些人不输入全名的区别。因此，我建议将该建议更改为“每个给定姓名和家族名称使用35个字符，或者单个字段包含全名使用71个字符”。|366689|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

@Ian Nelson: I'm wondering if others see the problem there.

Let's say you have split fields. That's 70 characters total, 35 for first name and 35 for last name. However, if you have one field, you neglect the space that separates first and last names, short changing you by 1 character. Sure, it's "only" one character, but that could make the difference between someone entering their full name and someone not. Therefore, I would change that suggestion to "35 characters for each of Given Name and Family Name, or 71 characters for a single field to hold the Full Name".

blocks|key|366693|text|请注意，许多文化都有“第二个姓氏”，通常称为姓氏。例如，如果你和西班牙人打交道，他们会喜欢把姓氏和他们的“姓”分开。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|366694|最好的方法是为姓名部分定义一个数据类型，将其用作姓氏的数据类型，并根据区域设置进行调整。|366695|entityMap^0|6|2|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

Note that many cultures have 'second surnames' often called family names. For example, if you are dealing with Spanish people, they will appreciate having a family name separated from their 'surname'.

Best bet is to define a data type for the name components, use those for a data type for the surname and tweak depending on locale.

blocks|key|3161787|text|您真正问的是一个相关但本质上不同的问题:为了将名称放入数据库，我需要多久截断一次？答案取决于不同长度的名字的频率以及所选择的最大长度。这种担忧与对数据库使用的资源的担忧相平衡。考虑到varchar字段的不同最大长度之间的开销差异是如此之小，我通常会犯错误，因为我永远不会被迫截断名称并使字段尽可能大。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3161788|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

What you're really asking is a related, but substantially different question: how often do I want to truncate names in order to fit them in the database? The answer depends both on the frequency of different lengths of names as well as the maximum lengths chosen. This concern is balanced by the concerns about resources used by the database. Considering how little overhead difference there is between different max lengths for a varchar field I'd generally err on the side of never being forced to truncate a name and make the field as large as I dared.

blocks|key|3161818|text|我知道我在这个问题上来晚了，但无论如何我都会添加这个评论，因为将来其他人可能会带着类似的问题来到这里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3161819|注意不要根据区域设置调整列的大小。首先，它让你陷入了维护的噩梦，抛开了人们迁移的事实，并随身携带他们的名字。|3161820|例如，拥有这些额外姓氏的西班牙人可以移居和生活在说英语的国家，并可以合理地预期他们的全名会被使用。俄罗斯人除了姓氏之外还有父名，一些非洲人的名字可能比大多数欧洲人的名字要长得多。|3161821|考虑到潜在的行数，让每一列尽可能地宽。我使用40个字符的名字，其他名字和姓氏，从来没有发现任何问题。|3161822|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I know I'm late on this one, but I'll add this comment anyway, as others may well come here in the future with similar questions.

Beware of tweaking column sizes dependent on locale. For a start, it sets you up for a maintenance nightmare, leaving aside the fact that people migrate, and take their names with them. 

For example, Spanish people with those extra surnames can move to and live in an English-speaking country, and can reasonably expect their full name to be used. Russians have patronymics in addition to their surnames, some African names can be considerably longer than most European names. 

Go with making each column as wide as you can reasonably do, taking into account the potential row count. I use 40 characters each for first name, other given names and surname and have never found any problems.

blocks|key|3161854|text|取决于谁将使用您的数据库，例如，非洲人的名字将用varchar(20)分隔姓氏和名字。但是，不同的国家不同，但是为了节省数据库资源和内存，请将姓氏和名字字段分开，并使用varchar(30)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3161855|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

depending on who is going to be using your database, for example African names will do with varchar(20) for last name and first name separated. however it is different from nation to nation but for the sake saving your database resources and memory, separate last name and first name fields and use varchar(30) think that will work.

blocks|key|364969|text|在英国，有几个政府标准成功地处理了大部分英国人口-护照办公室，司机和车辆牌照局，契据调查办公室和NHS。显然，他们使用不同的标准。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|364970|通过地契投票allows+300+characters更改你的名字；|offset|length|364971|364972|您的姓名长度没有法律限制，但我们对您的全名有300个字符(包括空格)的限制。|blockquote|364973|364974|364975|The+NHS+uses+70+characters+for+patient+names|364976|364977|患者姓名|364978|364979|格式/长度:最大an70|364980|364981|护照办公室的allows+30%2B30+first/last和驾驶执照(DVLA)总共是30个。|364982|364983|请注意，其他组织会对他们在制作的证件上显示的内容有自己的限制-英国护照办公室的限制是您的名字和姓氏各30个字符，而移民局的限制是您的全名总共30个字符。|364984|364985|entityMap|0|LINK|mutability|MUTABLE|url|https://deedpolloffice.com/changing-your-name/restrictions-on-names#maximum-length-name|1|http://www.datadictionary.nhs.uk/data_dictionary/data_field_notes/p/pat/patient_name_de.asp|2^0|0|6|L|0|0|0|0|0|0|4|14|1|0|0|0|0|0|0|6|N|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1C|8|@]|9|@$D|1D|E|1E|1|1F]]|A|$]]|$1|F|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|1H|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1K|8|@]|9|@$D|1L|E|1M|1|1N]]|A|$]]|$1|N|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|P|5|I|7|1P|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1R|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1T|8|@]|9|@$D|1U|E|1V|1|1W]]|A|$]]|$1|W|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|X|3|Y|5|I|7|1Y|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|20|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]|18|$5|13|14|15|A|$16|19]]|1A|$5|13|14|15|A|$16|17]]]]

In the UK, there are a few government standards which deal successfully with the bulk of the UK population -- the Passport Office, the Driver &amp; Vehicle Licensing Agency, the Deed Poll office, and the NHS. They use different standards, obviously.

Changing your name by Deed Poll <a href="https://deedpolloffice.com/changing-your-name/restrictions-on-names#maximum-length-name" rel="noreferrer">allows 300 characters</a>;

<blockquote>
 There is no legal limit on the length of your name, but we impose a limit of 300 characters (including spaces) for your full name. 
</blockquote>

The <a href="http://www.datadictionary.nhs.uk/data_dictionary/data_field_notes/p/pat/patient_name_de.asp" rel="noreferrer">NHS uses 70 characters for patient names</a>

<blockquote>
 PATIENT NAME 
 Format/length: max an70
</blockquote>

The Passport Office <a href="https://deedpolloffice.com/changing-your-name/restrictions-on-names#maximum-length-name" rel="noreferrer">allows 30+30 first/last</a> and Driving Licenses (DVLA) is 30 total.

<blockquote>
 Note that other organisations will have their own restrictions about what they will show on the documents they produce — for HM Passport Office the limit is 30 characters each for your forename and your surname, and for the DVLA the limit is 30 characters in total for your full name.
</blockquote>

blocks|key|3161953|text|答案可能因用于存储名称的数据库字段和HTML表单中的字段而异。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3161954|HTML中名称字段的长度可以由UX引导。|3161955|有一个study显示，在欧洲，引用：“名字的中位数是6.5个字符，姓氏是7.1个字符”。如果你看下面的图表，你会发现每个人都有10个字符，给定的名字和姓氏，足以拥有最佳的用户体验。|offset|length|3161956|​|3161957|📷|atomic|3161958|3161959|entityMap|0|LINK|mutability|MUTABLE|url|https://www.researchgate.net/figure/First-names-and-last-names-lengths-distributions_fig1_328894441|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f82421ae84a53367d9d5947c07af23d0.png|imageAlt^0|0|0|3|5|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$F|14|G|15|1|16]]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@$F|19|G|1A|1|1B]]|A|$]]|$1|M|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]|V|$5|W|R|X|A|$Y|Z|10|-4]]]]

The answer may deffer for a database field which is used to store the name, and for a field in a HTML form.
The length of the Name filed in a HTML can be guided by UX.
There is a <a href="https://www.researchgate.net/figure/First-names-and-last-names-lengths-distributions_fig1_328894441" rel="nofollow noreferrer">study</a> which shows that in Europe, cite: &quot;The median was 6.5 characters for the first names and 7.1 characters for the last names&quot;. If you look at the charts below you'll see that 10 characters for each, given name and family name, is enough to have optimal UX.
<a href="https://i.stack.imgur.com/Phncy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Phncy.png" alt="enter image description here" /></a>

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 <code>varchar(50)</code>, but then I started to wonder.
Is it more appropriate to use something like the <code>Text</code> 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 <a href="https://stackoverflow.com/questions/20958/list-of-standard-lengths-for-database-fields">this broader question</a> regarding similar issues.

What is a reasonable length limit on person "Name" fields?

SQL Server

数据库

MySQL

我有一个简单的网页表单，将允许未经认证的用户输入他们的信息，包括姓名。我为name字段设置了50个字符的限制，以便与我的数据库表保持一致，其中字段为varchar(50)，但随后我开始怀疑。是使用像Text列类型这样的名称更合适，还是应该将名称的长度限制为合理的长度？我使用的是SQL Server2005，以防在您的回...

问person "Name“字段的合理长度限制是什么？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问person "Name“字段的合理长度限制是什么？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问person "Name“字段的合理长度限制是什么？
EN