title: Standard Way of Storing Names in a Database
body: <p>I have recently been pondering names and the way we store them. Generally a person will have a First, Last and Middle name. If you want to be particularly complete you might add a suffix field, perhaps even a title field. So if someone wants to be "Dr. John Q. Public III", they can. But a person can have more than one honorific and more than one suffix. For that matter then could hve a hyphenate last name too. So what if you are "Dr. John Quintus Maximus Public-Doe III Ph.D. MD. RPh."? You could do:
  <Pre>
  Persons
      PersonID
      Prefix
      FirstName
      MiddleName
      LastName
      Suffix
  PersonHonorifics
      PHID
      PersonID
      Honorific
  PersonNames
      PANID
      PersonID
      NameOrder
  </pre>
  But then it gets to be a bear to work with, and no one ends up using them anyway. </p>
  
  <p>Is there a generally accepted "Standard Way" to store name data?</p>