Re: Modeling Address using Relational Theory

From: Gene Wirchenko <>
Date: Wed, 07 Sep 2005 10:03:14 -0700
Message-ID: <>

On 4 Sep 2005 19:26:37 -0700, "dawn" <> wrote:


>I might agree if it were the case that you could collect these data
>from a user in any order on an input form. I can put State/Province
>before City and people might have to change their habits, but they will
>be able to adjust much more handily than if I put addr2 before addr1 on
>a form. Gene was right when he said that you could code this as a
>single value and use markup of some sort to identify the second value
>from the first. Putting them in the opposite order would make a whole
>lot less sense than putting other values in an order that is not
>common. It would be more like having the user write a Word document
>with the last line on top.

     Chinese addresses are that way though. They go from least to most specific.

     Is this address issue really any different than Chinese (and some other) names which have the family name first? When I wrote a Web app in a course, I had provision in the customer data for whether the family name was before or after the given names.



Gene Wirchenko Received on Wed Sep 07 2005 - 19:03:14 CEST

Original text of this message