Re: People's names (was Re: sqlite3 error)

2006-10-17 Thread Hendrik van Rooyen
"Florian Diesch" <[EMAIL PROTECTED]>wrote: 8<-- >In Germany "von" is just a part of the name since 1919 when the nobility >was abolished by law. Thanks - was not aware of this - 1919 - just after the Great War, 1914-1918... - Hendrik

Re: People's names (was Re: sqlite3 error)

2006-10-17 Thread Florian Diesch
"Hendrik van Rooyen" <[EMAIL PROTECTED]> wrote: > "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: > > >> In message <[EMAIL PROTECTED]>, Hendrik van >> Rooyen wrote: >> >> > "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: >> > >> > 8< >> >

Re: People's names

2006-10-12 Thread Antoon Pardon
On 2006-10-11, Theerasak Photha <[EMAIL PROTECTED]> wrote: > On 10/10/06, Piet van Oostrum <[EMAIL PROTECTED]> wrote: >> > Roel Schroeven <[EMAIL PROTECTED]> (RS) wrote: >> >> >RS> It's the same here in Belgium. Except that our Van is with a capital V >> >in >> >RS> most cases; if it's a lower

Re: People's names

2006-10-11 Thread Theerasak Photha
On 10/11/06, Roel Schroeven <[EMAIL PROTECTED]> wrote: > My observation is that in general names keep hanging on to archaic forms > much longer than normal language. Examples: > > - A very common name around here is Hendrickx. In normal language, the > 'ckx' construction is replaced with 'ks'. > -

Re: People's names

2006-10-11 Thread Roel Schroeven
Theerasak Photha schreef: > On 10/10/06, Piet van Oostrum <[EMAIL PROTECTED]> wrote: >>> Roel Schroeven <[EMAIL PROTECTED]> (RS) wrote: >>> RS> It's the same here in Belgium. Except that our Van is with a capital V >>> in >>> RS> most cases; if it's a lower v it either indicates nobility or a

Re: People's names (was Re: sqlite3 error)

2006-10-10 Thread Leo Kislov
John J. Lee wrote: > Steve Holden <[EMAIL PROTECTED]> writes: > [...] > > > There would also need to be a flag field to indicate the canonical > > > ordering > > > for writing out the full name: e.g. family-name-first, given-names-first. > > > Do we need something else for the Vietnamese case? > >

Re: People's names

2006-10-10 Thread Theerasak Photha
On 10/10/06, Piet van Oostrum <[EMAIL PROTECTED]> wrote: > > Roel Schroeven <[EMAIL PROTECTED]> (RS) wrote: > > >RS> It's the same here in Belgium. Except that our Van is with a capital V in > >RS> most cases; if it's a lower v it either indicates nobility or a Dutch > >name. > > >RS> I don't

Re: People's names

2006-10-10 Thread Piet van Oostrum
> Roel Schroeven <[EMAIL PROTECTED]> (RS) wrote: >RS> It's the same here in Belgium. Except that our Van is with a capital V in >RS> most cases; if it's a lower v it either indicates nobility or a Dutch name. >RS> I don't see it as a problem. I prefer having Van Straeten and Van Stralen >RS>

Re: People's names

2006-10-10 Thread Jorge Godoy
Steve Holden <[EMAIL PROTECTED]> writes: > It seems like some sort of free text search on a "full name" field looks like > the only realistic globally-acceptable (?) option. This is what we opted doing. Normalization to this level wouldn't add much since there are a lot of "Smith"s that aren't r

Re: People's names

2006-10-10 Thread Jorge Godoy
"Theerasak Photha" <[EMAIL PROTECTED]> writes: > Also 'da' for Portuguese, which means roughly same as > Nederlands/Vlaams. Maybe. As usual: IANAE. It looks like the same but at least here in Brasil it isn't considered for sorting ("da Silva" should be sorted under "Silva", "de Souza" under "Souz

Re: People's names (was Re: sqlite3 error)

2006-10-10 Thread Steve Holden
Theerasak Photha wrote: > On 10/7/06, Lawrence D'Oliveiro <[EMAIL PROTECTED]> wrote: > > >>Just because most Western designers of databases do it wrong doesn't mean >>that a) you should do it wrong, or b) they will continue to do it wrong >>into the future, as increasing numbers of those designer

Re: People's names (was Re: sqlite3 error)

2006-10-10 Thread Theerasak Photha
On 10/7/06, Lawrence D'Oliveiro <[EMAIL PROTECTED]> wrote: > Just because most Western designers of databases do it wrong doesn't mean > that a) you should do it wrong, or b) they will continue to do it wrong > into the future, as increasing numbers of those designers come from Asian > and other n

Re: People's names (was Re: sqlite3 error)

2006-10-10 Thread Roel Schroeven
Hendrik van Rooyen schreef: > "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: > > >> In message <[EMAIL PROTECTED]>, Hendrik van >> Rooyen wrote: >> >>> "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: >>> >>> 8< >>> I wonder if we nee

Re: People's names (was Re: sqlite3 error)

2006-10-10 Thread Hendrik van Rooyen
"Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: > In message <[EMAIL PROTECTED]>, Hendrik van > Rooyen wrote: > > > "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: > > > > 8< > > > >> I wonder if we need another "middle" field for holding

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread John Machin
John J. Lee wrote: > "John Machin" <[EMAIL PROTECTED]> writes: > [...] > > This is all a bit OT. Before we close the thread down > > Do you have a warrant for that? I have some signed-but-otherwise-blank warrants, but I'm saving them for other threads :-) > > > , let me leave > > you with one w

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread John J. Lee
"John Machin" <[EMAIL PROTECTED]> writes: [...] > This is all a bit OT. Before we close the thread down Do you have a warrant for that? > , let me leave > you with one warning: > Beware of enthusiastic maintenance programmers on a mission to clean up > the dirty names in your database: > E.g. (1

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread John J. Lee
Steve Holden <[EMAIL PROTECTED]> writes: [...] > > There would also need to be a flag field to indicate the canonical > > ordering > > for writing out the full name: e.g. family-name-first, given-names-first. > > Do we need something else for the Vietnamese case? > > You'd think some standards bod

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread Hendrik van Rooyen
"Dennis Lee Bieber" <[EMAIL PROTECTED]>wrote: 8<-- > In the days of paper filing (I actually took Shorthand, and a > Business Machines & Filing course in High School to avoid Phys.Ed.) the > training for things like oriental names was to choose one for "surname

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread John Machin
Steve Holden wrote: > > Don't forget the UK, where the scots are accommodated by filing Mc > before Mac everywhere except the 'phone book, where IIRC they are > treated as equivalent. Same/similar phone book treatment here in Australia -- Mc is treated as though it were spelled Mac. An interestin

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread Lawrence D'Oliveiro
In message <[EMAIL PROTECTED]>, Hendrik van Rooyen wrote: > "Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: > > 8< > >> I wonder if we need another "middle" field for holding the "bin/binte" >> part (could also hold, e.g. "Van" for those n

Re: People's names (was Re: sqlite3 error)

2006-10-09 Thread Steve Holden
gt;>Iceland; neither is addressing Jon Jonsson as "Mr Jonsson", and BTW it >>can be their mother's name e.g. if she has more fame or recognition >>than their father. > > > Your bringing up the phone directory is a good point. That's probably the &

Re: People's names (was Re: sqlite3 error)

2006-10-08 Thread Hendrik van Rooyen
"Lawrence D'Oliveiro" <[EMAIL PROTECTED]> wrote: 8< > I wonder if we need another "middle" field for holding the "bin/binte" part > (could also hold, e.g. "Van" for those names that use this). NO! - I think of my surname as "van Rooyen"

Re: People's names (was Re: sqlite3 error)

2006-10-08 Thread Lawrence D'Oliveiro
onsson", and BTW it > can be their mother's name e.g. if she has more fame or recognition > than their father. Your bringing up the phone directory is a good point. That's probably the most widely-consulted list of people's names around, so it's worthwhile following whate

Re: People's names (was Re: sqlite3 error)

2006-10-08 Thread Paul Rubin
Steve Holden <[EMAIL PROTECTED]> writes: > > There would also need to be a flag field to indicate the canonical > > ordering > > for writing out the full name: e.g. family-name-first, given-names-first. > > Do we need something else for the Vietnamese case? > > You'd think some standards body woul

Re: People's names (was Re: sqlite3 error)

2006-10-08 Thread Steve Holden
Lawrence D'Oliveiro wrote: > In message <[EMAIL PROTECTED]>, Steve > Holden wrote: > > >>John Machin wrote: >> >>[lots of explanation about peculiarities of people's names] >> >>While I don't dispute any of this erudite displ

Re: People's names (was Re: sqlite3 error)

2006-10-07 Thread John Machin
Lawrence D'Oliveiro wrote: > In message <[EMAIL PROTECTED]>, Steve > Holden wrote: > > > John Machin wrote: > > > > [lots of explanation about peculiarities of people's names] > > > > While I don't dispute any of this erudite display of

Re: People's names (was Re: sqlite3 error)

2006-10-07 Thread Lawrence D'Oliveiro
In message <[EMAIL PROTECTED]>, Steve Holden wrote: > John Machin wrote: > > [lots of explanation about peculiarities of people's names] > > While I don't dispute any of this erudite display of esoteric > nomenclature wisdom the fact remains that many (predomin