The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
More seriously…. if you think that’s bad enough, try adding a drop-down selector for UK counties – it’s next to impossible. Scotland and Wales both have two incompatible systems for defining counties/”administrative districts”, and while one may be “official”, try telling that to upset users because you used one and not the other…
And, going back to your original point and my reply, I once had a postcard addressed to me in “…. Wales, England”. The most astonishing thing was that it actually got delivered!
Yeah totally. It's way too verbose. Rather than re-key stuff, I just decided to add a shorthand column to the DB. So if for whatever reason I need to show the country at least it won't read like a paragraph or novel.
Thanks man, turns out I watched that same exact video. Totally wish I would've had your offer about a week ago. I just spent the entirety of this week cleaning up and tweaking my geo data (to the tune of 4million-ish cities) with all this new fancy ISO 3166 stuff. I have a about 3.5k off the wall places I have no real clue wtf their proper M49 code is though. I ended up using some private ones I found off of an XML feed on unicode.org.
Just out of curiosity, how are you naming your "regional" table that contains states, provinces, etc? I can't call mine State and I don't think Province will apply to every country in the world.
"State" or "State/region" seems to be in common use. As you say, there is no one word used by all countries - "county" in the UK, "department" in France, etc - but "state" is pretty much universally recognised, I think.
Likewise, "Zip code" seems also to be gaining universal acceptance, though many places still prefer "Post code", so maybe "Zip/Post code" is better for that.
Only thing you can be sure if is that no matter what you do, someone will be upset....
So, let's say I want to store the address - including country - for a user in a database who lives in Scotland. Should I now be saying: John Doe, XYZ, in the friggin United Kingdom of Great Britain and Northern Ireland? ...
The information that I have says that John Doe does not exist in the UKOGBANI. It is Joe Bloggs there...
.uk wasn't actually our top-level domain name, it was used unofficially and has now been adopted, the UK's real TLD was .gb so it makes sense the ISO codes also use GB. You would never store "Scotland", "England" etc as someone's country as they are not sovereign states and only sovereign states are globally recognised as countries. The only time you'd store England as someone's country is if you are an American developing an American website and think that England and the UK are the same thing.
In reality, when you send snail-mail, the address could be something like:
Mr Richard Roe
123 The High Street
near Pigs End
Middx HA8 8UT
Glasgow GU9 7TR
Scotland (optional - you would never say England but might specify the smaller places or they get pissed off that England supports them and the English don't give a crap about them. Actually, no one who lives inside the M25 even acknowledges that anyone lives outside of it)
Note that Middx is short for Middlesex which the Royal Mail do not recognise and is not on maps any more but everyone still uses it.
Last Visit: 16-Jun-19 7:19 Last Update: 16-Jun-19 7:19