[Gpe-list] Bad database design in Contacts

[Florian Boor]

Hi,

Graham Cobb wrote:
> On Wednesday 30 May 2007 12:05, Florent de Dinechin wrote:

> I can't comment on why the particular database structure was chosen but I do 
> know that the situation is more complex than it may appear.  For example, the 
> vCard standard defines two completely separate fields for the textual 
> representation of the name (FN) and for the structured breakdown of the name 
> (N -- which consists of Family Name, Given Name, Additional Names, Honorific 
> Prefixes, and Honorific Suffixes).  

this is more or less the idea behind the database structure we use. The problem
is that you can not really generate the name string that should be displayed
from the single components (which you want for searching) - there are too many
different conventions depending on language and culture how names are built.

Greetings

Florian

-- 
The dream of yesterday                  Florian Boor
is the hope of today                    Tel: +49 271-771091-14
and the reality of tomorrow.            Fax: +49 271-771091-19
[Robert Hutchings Goddard, 1904]        florian.boor at kernelconcepts.de

1D78 2D4D 6C53 1CA4 5588  D07B A8E7 940C 25B7 9A76