[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: storing names for sorting



At 01:50 PM 10/11/00 +0200, Joeri van Ruth wrote:
>When storing people in a database, one often wants to sort them by
>their last name.  But sometimes, parts of the last name should be
>ignored while sorting.  For example, my name is "Joeri van Ruth", and
>my last name is "van Ruth", but my name should be listed under "R", not
>under "v".  
>
>Which attribute can best be used for storing the part of the last name
>that is relevant for sorting?

I'm not aware of any attribute specifically designed for such.
I suggested defining something like:

  ( 1.1 NAME ( 'ln' 'listingName ) 
        DESC 'a name used to determine listing order'
        SUP name SINGLE-VALUE )

Kurt