ISO_3166-1 codes for the UK folks...
-
"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....
-
It would be an Inverness kiss in that case. Except he's actually very peaceful outside his verbal skills.
Wrong is evil and must be defeated. - Jeff Ello
-
.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.
Wrong is evil and must be defeated. - Jeff Ello
-
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....
A_Griffin wrote:
Only thing you can be sure if is that no matter what you do, someone will be upset....
:laugh: Wise words.
Jeremy Falcon
-
Not just Americans I can assure you.
Wrong is evil and must be defeated. - Jeff Ello
Yes, the majority of English people don't know the difference either.
-
.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 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.