"The Hague" is a city name. ("Den Haag" in Dutch)
So it has to be "The Hague Philharmonic Orchestra"
Not: "Hague Philharmonic Orchestra, The"
Or, where it would appear: "The Hague Philharmonic Orchestra, The" (would appear as The The Hague Philharmonic Orchestra) (not very probable to appear anywhere I think:)
Really needs a fix, but nothing much to discuss about in fact, I'm going for the support request.
Quite annoying having that one waiting in draft... (didn't find it in my collection & submission today, before I remembered it was probably the bugged one...)
I've put a space in front of the ANV for the moment, don't intend to do a waiting job. Most system changes take at least a few days, sometimes a bit longer:)
nerdfly imagine a phonebook where every name was filed under 'M' for Mr or Miss
Like ORange Country phonebooks with "Tran"?
Seriously, though, there are ways that many other databases use for ignoring the leading "The" (and in some cases other leading prepositions like "A"). It's antiquated to use a trailing ", The" in names.
imagine a phonebook where every name was filed under 'M' for Mr or Miss
it would only be a problem if you tried browsing artists alphabetically... Personally I never do and I don't think many people do (TBH I don't know if it's still even possible!)
cellularsmoke It's antiquated to use a trailing ", The" in names.
Antiquated, counterintuitive, confusing for collaboration artists (should you enter "Artist 1, The & Artist 2" or "Artist 1 & Artist 2, The"? When you see "Artist 1 & Artist 2, The" is the "The" supposed to be before Artist 1 or Artist 2?)
AFAIK that rule was indeed originally introduced for sorting purposes and database balancing(?). I think none of these are still concerns to date.
There is a way where 'The' can be ignored in sorting, but it will pose the same bug as with the forced error. It will sort names with 'The Hague' under 'H' instead of 'T'...
The only way out would be a manual list of exceptions (non-trivial stuff indeed...)