|
It would be daft to put all that - you can just use "UK" or "United Kingdom" alone. There is no need to add Scotland at all, though no one will actually laugh if you put "Scotland, UK".
|
|
|
|
|
Ok cool. Thanks for the help man. 
Jeremy Falcon
|
|
|
|
|
Well, you wouldn't spell out, "The United States of America", either I bet.
I don't think that standard is designed for your purpose.
If I recall correctly, my wife writes "Europe" on the cards she sends to relatives in Austria and that small wet island. 
|
|
|
|
|
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.
|
|
|
|
|
|
Great minds think alike... I totally watched that same exact video... just to make sure that if I "engineer" something it came out ok.
|
|
|
|
|
|
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.
Oh the joys of making an international app.
|
|
|
|
|
Jeremy Falcon wrote: how are you naming your "regional" table
Subcountry.
A few years ago we developed scripts to import and clean geo-data from several sources. Cities, subcountries, countries, regions, continents. The lot. PITA.
cheers
Chris Maunder
|
|
|
|
|
Chris Maunder wrote: Subcountry
I called mine province, but I like the idea of making it more generic.
Chris Maunder wrote: A few years ago we developed scripts to import and clean geo-data from several sources. Cities, subcountries, countries, regions, continents. The lot. PITA.
If I ever have to do this again for this DB, I'm gonna follow suit.
Jeremy Falcon
|
|
|
|
|
"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....
|
|
|
|
|
Isn't a state a sovereign country?
Unless you're from the USA.
|
|
|
|
|
A_Griffin wrote: Only thing you can be sure if is that no matter what you do, someone will be upset....
 Wise words.
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: 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...
I'm retired. There's a nap for that...
- Harvey
|
|
|
|
|
H.Brydon wrote: It is Joe Bloggs there...
Or rather, "the man on the Clapham omnibus". 
|
|
|
|
|
I note that both France and Germany are on the ISO 3166 maintenance agency (see ISO 3166 - Wikipedia ). Could Brexit have something to do with it?
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
.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.
|
|
|
|
|
Not just Americans I can assure you.
|
|
|
|
|
Yes, the majority of English people don't know the difference either.
|
|
|
|
|
In reality, when you send snail-mail, the address could be something like:
Mr Richard Roe
123 The High Street
Trotters Bottom
near Pigs End
Middx HA8 8UT
UK
or
Jock MacTavish
The Brewery
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)
UK
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.
|
|
|
|
|
|
Yup. Them wuz the days! (NOT!)
Get me coffee and no one gets hurt!
|
|
|
|
|
Jeremy Falcon
|
|
|
|
|
Good old days?
Sounds to me like what Michael Martin does every day?
I hear core memory is still bleeding edge tech in Australia, rumors are Telstra's got almost 61k.
Signature ready for installation. Please Reboot now.
|
|
|
|
|
Those were the good old days because I was playing with tonka toys then.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
