First name, middle name, last name. Why not Full Name?

Asked 2009-07-13T22:00:01.937

I am trying to find a better approach for storing people's name in the table. What is the benefits of 3 field over 1 field for storing persons name?

UPDATE

Here is an interesting discussion and resources about storing names and user experience

Merging firstname/last name into one field

database database-design user-interface

Edit Report

1 Answer

Some of the issues can be solved by also storing an additional column like PreferredName. We do that in our DB and also store prefix column and a suffix column. e.g 'Prof Henry W Jones Jnr' with preferred name as 'Indiana Jones'.

answered 2009-07-13T23:57:04.337

First name, middle name, last name. Why not Full Name?

1 Answer

Your Answer