in reply to Re: Idea: Moose Mutal Coercion
in thread Idea: Moose Mutual Coercion

Indeed. Dividing names up into "first name", "last name", etc fields is an internationalisation disaster waiting to happen.

Just have a single "name" field for storing the person's full name. If you need to be able to address people in a variety of ways ("Joe Bloggs" on an envelope, "Dear Joe" at the start of the letter, and "Mr J Bloggs" on billing) then expand that into "formal_name", "informal_name", "legal_name", etc fields.

Splitting the name up and then recombining it simply won't work once you step out of the cosy little world of $ENV{LC_ALL}.

Replies are listed 'Best First'.
Re^3: Idea: Moose Mutal Coercion
by Old_Gray_Bear (Bishop) on Feb 14, 2012 at 17:18 UTC
    I once worked with a gentleman named 'Tiger'. It said that on his birth certificate, driver's licenses, military ID, and Social Security records. He drove the Payroll and Taxes into fits. Another place I worked had a 'Gunther Karl-Dieter von Augsbach von und zu Berchtal am Saur Zimmerman'. Payroll tried several times to get an acceptable abbreviated name, we finally expanded the name field to 200 characters.

    ----
    I Go Back to Sleep, Now.

    OGB