My last name has a space in it. It's been less than a month since the last time it was rejected by a form. One of my oldest online friends has only one name. Assume nothing, permit everything.
On Wed, 13 Nov 2019, 15:23 Swithun Crowe, <swit...@swithun.servebeer.com> wrote: > Hello > > SS> Those are all excellent examples of why you should /not/ split up a > SS> name into components. For artists of all sorts (including the author > SS> I used) what you care about is their publishing name. Plus, how do > SS> you identify the part of a name which you would call 'surname' ? > > One needs domain knowledge - knowing that Arouet is the surname of the > artist known as Voltaire. In my use cases, this is possible (the > researchers do it, not me). And by encoding one's domain knowledge, one is > preserving it for future users who may not have it. > > Of course people are most interested in the publishing name, so Voltaire > comes under V. But that isn't the only use that people might have for the > data. So splitting the names and adding extra logic to display them in > different ways in different contexts is, I think, the optimal solution. > > SS> Why would you want to sort by surname ? Why is it important that > SS> "Harris' is shown below "Harrington" ? Don't substring searches help > SS> you more than sorted lists ? Wouldn't you miss the 'Parkes' family > SS> name from John Wyndham and the 'Ruiz' from Picasso if you were > SS> searching a sorted list ? > > If one had a million names from many different cultures (e.g. a customer > database), then there may be no need/possibility to maximise reuse of the > data, and a substring search would be the only way to find the name you > want. But for a database of 200 French playwrights, a suitably sorted list > is what users want. > > Swithun. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users