|
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.
|
|
|
|
|
|
"269 counts of wire fraud and money laundering"? Hopefully, that'll put him away for a few years. 
Pity it's only a middle man though.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Quote: Hopefully, that'll put him away for a few years
Yup! He should get a one year sentence for each of the 269 counts. These sentences to be served sequentially! 
Get me coffee and no one gets hurt!
|
|
|
|
|
OriginalGriff wrote: that'll put him away for a few years
Not if this was the UK. If it was the UK he'd be suing the police for reading his emails.
|
|
|
|
|
@JeremyFalcon, is that you?
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
Noooo! Jeremy is a nice guy! Don't insult him like this.
Get me coffee and no one gets hurt!
|
|
|
|
|
Thanks man. Although it's not as easy affording prostitutes these days with the economy and all. So sometimes you gotta do what you gotta do... 
Jeremy Falcon
|
|
|
|
|
If you become the prostitute, the sex will make you money.
|
|
|
|
|
You raise a good point, sir.
Jeremy Falcon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
