[mb-users] Sortingorder Dutch tussenvoegsel

[Fred Marchee]

> Reading through the discussion I think I didn't make a things very 
> clear in the first place. (my fault!)
>
> It is not the sortingorder I am complaining about, it's not the way 
> names are sorted (that okay, they are sorted the right way) It's the 
> way we had to write down the sortingorder, for the database. I want a 
> database that understands there is no difference between:
>
> 1 - Boudewijn de Groot
> 2 - Groot, Boudewijn de
> 3 - Groot, de, Boudwijn
>
> being:
> 1: The displayname
> 2: The way names are sorted in phonebooks and we are familiar with in 
> Holland
> 3: The way we had to enter names in a (for instance Musicbrainz) 
> database so that the database can sort the names in a right order.
>
> I am very well aware that it seems absolutely no problem to create 
> such a system but because there are a lot of exceptions in the Dutch 
> language it's almost impossible to make it 100% proof. And then we 
> come to a point where we had to help the database with three columns. 
> And I have ABSOLUTELY no problems with the proposed one. It is just 
> the way I read it, "Groot, de, Boudewijn" looks very strange to me. 
> But on the other hand, what am I complaining about, I will start 
> changing all the Dutch names with a not consistent sortname to "Last 
> name, tussenvoegsel, First name"
>
> Consistency is very important in a Database, and I will cancel the 
> Freek de Jonge edit.
>
> Perhaps it is also better to put a text in the wiki (that's where it 
> all started) that: "Last name, tussenvoegsel, First name" leads to the 
> same result as "Last name, First name tussenvoegsel" and that we have 
> to do with a sortingmachine working this out the right way. It helps 
> against stupid guys like me ;-)
>
> Thanks,
>
> Fred.
>

There are sometimes moments you really think that you are crazy. Moaning 
about the way the sortorder is written is one thing, accepting the fact 
that computers are crazy and writing a confession that you have accepted 
the way a sortname is written is another thing.

But when I started correcting wrongly entered sortnames in a way the 
computer likes them I discovered that the sort order thingy is SPEAKING 
HUMAN!!!!

I LOVE YOU GUYS, I WILL NEVER ENTER WRONG RELEASES ANYMORE, I WILL NEVER 
ENTER WRONG VARIOUS ARTISTS ANYMORE, I WILL ALWAYS PRESS GUESS CASE AND 
AND AND............ I am speechless.

The only problem right now is that I had to change a lot of names like a 
promised NO PROBLEM!

Thank you guys

(a very happy Fred) With a last name: "Marchée genaamd Bratengeijer" 
perhaps you can understand (when knowing my complete last name) that I 
am fighting every time to put my name in the right way and order with 
the é and sorted under the "M".

Thanks again.