Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. ISO_3166-1 codes for the UK folks...

ISO_3166-1 codes for the UK folks...

Scheduled Pinned Locked Moved The Lounge
databasehelpquestion
27 Posts 11 Posters 57 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A A_Griffin

    "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....

    P Offline
    P Offline
    pt1401
    wrote on last edited by
    #21

    Isn't a state a sovereign country? Unless you're from the USA.

    1 Reply Last reply
    0
    • A A_Griffin

      Sarcasm? He'd thank you with a Glasgow kiss....

      J Offline
      J Offline
      Jorgen Andersson
      wrote on last edited by
      #22

      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

      1 Reply Last reply
      0
      • F F ES Sitecore

        .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.

        J Offline
        J Offline
        Jorgen Andersson
        wrote on last edited by
        #23

        Not just Americans I can assure you.

        Wrong is evil and must be defeated. - Jeff Ello

        F 1 Reply Last reply
        0
        • C Chris Maunder

          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

          J Offline
          J Offline
          Jeremy Falcon
          wrote on last edited by
          #24

          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

          1 Reply Last reply
          0
          • A A_Griffin

            "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....

            J Offline
            J Offline
            Jeremy Falcon
            wrote on last edited by
            #25

            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

            1 Reply Last reply
            0
            • J Jorgen Andersson

              Not just Americans I can assure you.

              Wrong is evil and must be defeated. - Jeff Ello

              F Offline
              F Offline
              F ES Sitecore
              wrote on last edited by
              #26

              Yes, the majority of English people don't know the difference either.

              1 Reply Last reply
              0
              • F F ES Sitecore

                .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.

                R Offline
                R Offline
                R Giskard Reventlov
                wrote on last edited by
                #27

                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.

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups