[prev] [thread] [next] [lurker] [Date index for 2004/04/29]

From: peter (Peter da Silva)
Subject:
Date: 16:34 on 29 Apr 2004
>   That's because programmers and database designers think there are
>   simple rules to this sort of thing, even though the rules are
>   anything but simple, even without people who are exceptions to the
>   rules.  For example, Sir John Smith is "Sir John" in situations
>   where Mr Fred Jones is simply "Fred".  Simplifying your database to
>   include title, firstname and lastname is oversimplification, and
>   you end up with workarounds like we have here where "Sir John" is
>   in the title field and there is a null value for the firstname.

You really need to have a separate field for "personal name", for cases
like this, and people like Maddog who go by nicknames or stage names.

There's stuff above here

Generated at 14:02 on 01 Jul 2004 by mariachi 0.52