Personal names in a global application: What to store [closed]

by

There isn’t really a universal structured way to do this. I’d have a big field for “Full Name” and another field for “Display Name”. Both unicode.

For example, in Spanish-speaking countries, IIRC, people usually have FOUR names. Two given names, and two surnames (one from the father, one from the mother). Arabs essentially have a linked list of names as far back as they choose to go (So-and-so, son of so-and-so, son of so-and-so, …). East Asian countries tend to put the given names last, whilst Europeans put the given names first.

More Related Contents:

  1. Normalization in database management system
  2. How to perform compound queries with logical OR in Cloud Firestore?
  3. Database development mistakes made by application developers [closed]
  4. Copying PostgreSQL database to another server
  5. Surrogate vs. natural/business keys [closed]
  6. Do you use source control for your database items? [closed]
  7. What is NoSQL, how does it work, and what benefits does it provide? [closed]
  8. database vs. flat files
  9. First name, middle name, last name. Why not Full Name?
  10. Can we update primary key values of a table?
  11. What are the design criteria for primary keys?
  12. How do I output the results of a HiveQL query to CSV?
  13. SQLite UPSERT / UPDATE OR INSERT
  14. Elastic search, multiple indexes vs one index and types for different data sets?
  15. In terms of databases, is “Normalize for correctness, denormalize for performance” a right mantra?
  16. Full-text search in NoSQL databases [closed]
  17. Import SQL dump into PostgreSQL database
  18. Can I do transactions and locks in CouchDB?
  19. Multivalued Fields a Good Idea?
  20. Elasticsearch query to return all records
  21. How to login and authenticate to Postgresql after a fresh install?
  22. Update the value of a field in database by 1 using codeigniter
  23. Versioning Database Persisted Objects, How would you? [closed]
  24. What are the differences between B trees and B+ trees?
  25. What is the default Precision and Scale for a Number in Oracle?
  26. What is caching?
  27. How to make a UUID in DynamoDB?
  28. Count array elements that matches condition
  29. Maximum number of rows in a sqlite table
  30. Mysql service won’t start, InnoDB init function error

Leave a Comment